Or, you could retrieve the first record of the table(s) sorted backwards. . . .
-----Original Message-----
From: Boris Nadler [SMTP:c_nadler@QUALCOMM.COM]
Sent: Wednesday, October 07, 1998 4:17 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: ? Last Record
Phil,
#END-FILE is used for the flat files processing:
"The variable #end-file is set to one (1) if end of file occurs on READ.
Otherwise it is set to zero (0). Your program should check this variable
after each READ command"
I'd use BEGIN-SELECT twice : first to get rows count and then to do special
frocessing
for the last row. Its not very efficient but I'm not aware about system
variable or function
you can use for the last row processing in SQR.
Hope its help.
Boris. ( Qualcomm Inc., 619/651-8571 )
At 04:17 PM 10/7/98 -0400, you wrote:
>
>
>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
>
>
>
>