See, Martijn:
If retrieved record has been 2/28/2004, then I want to retrieve the
record inserted immediately before. May be it isn’t before day.
Carlos.

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

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

Yes, I understand. But do you. What is "the row prior to the
selected row"?

A row ONLY exists in a resultset. In a table, there's no order
of rows. What defines " a prior row "?

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=129gosuqr/M=298184.6018725.7038619.3001176/
D=groups/S=1705115386:HM/EXP=1109939487/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=524158322>

_____

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]