RE: Variable ORDER BY

Thanks Mark...thought it would be easy like a select.


> -------- Original Message --------
> Subject: Re: Variable ORDER BY
> From: MWalter@xxxxxxxxxxxxxxx
> Date: Wed, December 08, 2004 3:45 pm
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> 
> You need to take a look at the PREPARE and DEFINE CURSOR statements.
> 
> Thanks,
> 
> Mark
> 
> Mark D. Walter
> Senior Programmer/Analyst
> CCX, Inc.
> mwalter@xxxxxxxxxx
> http://www.ccxinc.com
> 
> 
>                                                                            
>              michael@ryantechn                                             
>              ology.com                                                     
>              Sent by:                                                   To 
>              midrange-l-bounce         midrange-l@xxxxxxxxxxxx             
>              s@xxxxxxxxxxxx                                             cc 
>                                                                            
>                                                                    Subject 
>              12/08/2004 03:42          Variable ORDER BY                   
>              PM                                                            
>                                                                            
>                                                                            
>              Please respond to                                             
>              Midrange Systems                                              
>                  Technical                                                 
>                 Discussion                                                 
>              <midrange-l@midra                                             
>                  nge.com>                                                  
>                                                                            
>                                                                            
> 
> 
> 
> 
> 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...
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.