Bind Variables in an order By Clause

Article View: borland.public.delphi.database

Article #202

Back to borland.public.delphi.database Previous Next

#202

From: 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?

Technical Details

Message-ID: <1123079264.434905.267370@g14g2000cwa.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 115d96,ec6d056b6ac987ea,start
X-Google-Attributes: gid115d96,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "Mitch" <mgillesp@uoguelph.ca>
Newsgroups: borland.public.delphi.database
Subject: Bind Variables in an order By Clause
Date: 3 Aug 2005 07:27:44 -0700
Organization: http://groups.google.com
Lines: 13
Message-ID: <1123079264.434905.267370@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 137.94.11.222
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123079270 4916 127.0.0.1 (3 Aug 2005 14:27:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 3 Aug 2005 14:27:50 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=137.94.11.222;
   posting-account=mXo9Jw0AAABnmcasWVJEKrRxd8lTu8W8