Since you said "iterate", perhaps you want just this:

FOR SELECT DATE_INI
FROM SALE
WHERE DATE_INI <= :VDATE
ORDER BY DETE_INI DESC;

Ivan

----- Original Message -----
From: "Ivan Prenosil" <Ivan.Prenosil@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, March 03, 2005 1:48 PM
Subject: Re: [firebird-support] How to iterate through the records


>
> Do you mean something like this
> SELECT MAX(DATE_INI) FROM SALE WHERE DATE_INI < :VDATE;
>
> Ivan
>
> ----- Original Message -----
> From: "Carlos Arguilar" <carlos_arguilar@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Thursday, March 03, 2005 1:02 PM
> Subject: [firebird-support] How to iterate through the records
>
>
>
> 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