RE: SQL Select from a record

["Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx>]

Override the file to the correct member prior to executing the SQL statement.


> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Wills, Mike N. (TC)
> Sent: Friday, November 21, 2003 10:30 AM
> To: RPG Mailing List
> Subject: SQL Select from a record
> 
> 
> I am accessing a file with multiple members. I need to be 
> able to use SQL to
> get at a record other than the default record. How do I do 
> this in SQL?
> 
> Mike Wills
> Lawson Programmer/Administrator
> Taylor Development
> Email: mnwills@xxxxxxxxxxxxxx
> Direct Line: (507) 625-3187
> 
> CONFIDENTIAL INFORMATION
> 
> NOT TO BE COPIED WITHOUT AUTHORIZATION
> 
> The information contained in this electronic mail 
> transmission may contain
> privileged communications and/or confidential information 
> intended only for
> the use of the named recipient(s).  If the reader of this 
> information is not
> the named recipient(s) or you receive this transmission in 
> error, please:
> (1) immediately notify us by return electronic  transmission at
> mnwills@xxxxxxxxxxxxxx; and (2) permanently delete this 
> message from your
> computer and all servers and other stored devices.
>