Subject | How to iterate through the records |
---|---|
Author | Carlos Arguilar |
Post date | 2005-03-03T12:02:23Z |
Hello:
I would like know if exists a manner of iterate through the records
inside a stored procedure. For instance:
I created a sp with following statement:
SELECT DATE_INI FROM SALE WHERE DATE_INI = :VDATE;
Well, I need, next, retrieve the record prior to the record retrieve for
the select clause above.
How to do it?
Thanks for help.
Regards,
Carlos Arguilar
[Non-text portions of this message have been removed]
I would like know if exists a manner of iterate through the records
inside a stored procedure. For instance:
I created a sp with following statement:
SELECT DATE_INI FROM SALE WHERE DATE_INI = :VDATE;
Well, I need, next, retrieve the record prior to the record retrieve for
the select clause above.
How to do it?
Thanks for help.
Regards,
Carlos Arguilar
[Non-text portions of this message have been removed]