Bind Variables in an order By Clause

Thread View: borland.public.delphi.database

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Mitch Wed, 03 Aug 2005 14:27

#202

Author: Mitch
Date: Wed, 03 Aug 2005 14:27

12 lines
1339 bytes

hello Everyone..

  Im trying to execute an order by SQL command during run time on a
TwwDBGrid.  My Dataset has a bind variable declare as Ordinal. When I
run the following command, my qry does not order properly...


aQry.SQL.Add('SELECT * FROM SRS.CISA_MOD14_APPSPROCESSORDER_V WHERE
APPSMETHODID = :APPSMETHODID ORDER BY :ORDINAL');


Any have any ideas?

Re: Bind Variables in an order By Clause

#205

Author: Riki Wiki Google
Date: Sat, 06 Aug 2005 07:44

6 lines
1148 bytes

> Any have any ideas?

Hoi Mitch

Take a look here:
http://delphi.wikicities.com/wiki/Delphi_Newsgroups

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads