|
When I have used an order by in embedded SQL it has always been a field in the file like this <snip> FROM PrsnXref where (xrssn1 = 0 or xrssn2 = 0 or xrssn3 = 0 or xrssn1 > 776) ORDER By xplname, xpfname, xpinit, xpsuffx <snip> The where clause can have a variable but I don't see the use for a host variable in the order by HTH, Dave Boettcher >>> michael@xxxxxxxxxxxxxxxxxx 12/08/2004 2:42:03 PM >>> How can I use a variable ORDER BY clause in an embedded SQL statement? This doesn't work... C/EXEC SQL C+ Declare MyCursor Cursor For C+ Select * C+ From Myfile C+ Order By :MyField C+ For Read Only C/End-Exec I know I have to do something different because it's a variable that contains a field name, but I dunno what that different thing is. TIA...
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.