Re: ? Last Record

[Daniel Guynes <Daniel_Guynes@PEOPLESOFT.COM>]

I do believe there is a reserved variable called

#END-FILE

that is internally kept within the SQR.  It is set to 1 if the end of file
occurs.
I have never used it, so I can not help you there.

Hope it helps,

Cheers,

Danny





 (Embedded
 image moved   Phil Roell <phil.roell@NATINST.COM>
 to file:      10/07/98 03:44 PM
 pic25032.pcx)




Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Daniel Guynes)
Subject:  ? Last Record




Does SQR provide a flag that tells you when it has selected the last record
in a
select statement?

Thanks,

Phil

pic25032.pcx