--- In firebird-support@yahoogroups.com, "Craig" <cstevens@d...>
wrote:

> Thanks Adam for your input, this is the SQL Text that is used to
> extract some records off the server.
>
> 'SELECT FIRST 1000 SKIP 10 * FROM SITETRANSACTION ORDER BY T_ADDED
> ASCENDING'
>
> If i remove the SKIP 10 part of the statement, then the query works
> fine.
>
> Can you see why this may not work ?
>
> thanks

Craig,

I have just copied that query and renamed the table name and field
name to something in this database and it works fine.

SELECT FIRST 1000 SKIP 10 * FROM shift ORDER BY starttime
ASCENDING

I am using FB 1.5.2

Adam