Magno Machado wrote:

>> Yes you are wrong. As I and others have already answered you tables are
>> unordered sets of rows. There is no position. Postion comes to play on
>> your
>> client side when you see your data in some nice grid
>>
>
> Ok.
> So, how does first/skip works?
>
>

I am not talking about implementation details (since I don't know FB
code) but something on this line:

select first X skip Y from foo

In the fetch loop, skip (does not return to the client) the Y first ROWS
and return the X next rows, stop as soon as X records are returned or
the end of the result set are reached.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br