Re: problem

["Singh, Rajvirendra ( NYSDS )" <RajvirendraSingh@EXCHANGE.ML.COM>]

Hi Ravi,

There is no such flag/variable in SQR however you can get it by programming
logic. May be following code help you.
Begin-Procedure xxxx
Move 'N' to $end-of-rec
Begin-Select
col1
col2

        Move 'Y' to $end-of-rec
>From yyyyy
End-Select

If $end-of-rec='Y'
 xxxxxxxx
else
 xxxxxxxxx
end-if


        -----Original Message-----
        From:   ravi kumar [SMTP:ammalu@HOTMAIL.COM]
        Sent:   Tuesday, October 20, 1998 9:03 AM
        To:     Multiple recipients of list SQR-USERS
        Subject:        problem

        Hi all

        I have a problem...Iam new to SQR...is there any way to find end of
        Record in SQL statemetns. I mean  after retrieving all the records i
        want to display something.

        Note: Iam not using any files...iam using Begin-select andf
end-select.

        Thanks in Advance
        Ravi

        ______________________________________________________
        Get Your Private, Free Email at http://www.hotmail.com