Hi Martijn,
Of course, I have a single row. However, if the row, for example,
retrieved : 2/28/2004. How to get the record prior to this in the table.
This record isn’t 2/27/2004 needs. Do you understand?
Regards,
Carlos Arguilar

-----Mensagem original-----
De: Martijn Tonies [mailto:m.tonies@...]
Enviada em: quinta-feira, 3 de março de 2005 09:10
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] How to iterate through the records

Hello Carlos,

> 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?

In you get your resultset (like from the SELECT statement above),
then what is the "record prior to the record retrieved" from the
resultset?

Quick answer: there isn't any. You only have the resultset (being a
single
row, no row or multiple rows) to deal with.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
SQL
Server
Upscene Productions
http://www.upscene.com





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129qu8k1o/M=298184.6018725.7038619.3001176/
D=groups/S=1705115386:HM/EXP=1109938125/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=451785566>

_____

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]