× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.