Re: problem

["C. Willis III" <ceprn@HOTMAIL.COM>]

Gordon,

I agree with you that an end-of-rows is implicit with a select
statement, but the method you have described below is a double-edged
sword, since your command will execute even if the select statement
returns no rows.

Ravi,

If you need it to execute every time, this method is acceptable; if you
need it to only execute when valid rows have been returned in a select
statement, you need to set a flag and check it such as what Raj Singh
suggested in his reply.  You need to be careful which method you chose
and adapt it to your needs at that situation.

clark

----Original Message Follows----

The end of rows stuff is implicit.

Begin-Procedure xx

Begin-select
anything

  some-SQR-Code

from a
where
a.gg=1
end-select

This-code-executed-after-end-of-select-all-rows-processed

end-procedure



> -----Original Message-----
>
> 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