Hi Ivan:
I Think so! This statement will retrieve only the first date prior to
:VDATE, isn’t it?
Thanks,
Carlos.

-----Mensagem original-----
De: Ivan Prenosil [mailto:Ivan.Prenosil@...]
Enviada em: quinta-feira, 3 de março de 2005 09:48
Para: firebird-support@yahoogroups.com
Assunto: 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






Yahoo! Groups Sponsor


ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=12940vuun/M=298184.6018725.7038619.3001176/
D=groups/S=1705115386:HM/EXP=1109940513/A=2593423/R=0/SIG=11el9gslf/*htt
p:/www.netflix.com/Default?mqso=60190075> click here


<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=group
s/S=:HM/A=2593423/rand=920670312>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]