--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...>
wrote:

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

I checked and it looks like i am currently using as my test machine,
version 1.5.0.4290 of Classic Server, is it possible there is an
issue with this version for this operation, i guess i can install
v1.5.2

tar