--- In firebird-support@yahoogroups.com, "Craig" wrote:

> --- In firebird-support@yahoogroups.com, "Adam" wrote:
> > Craig,
> >
> > Are you able to run the query from isql or does that give the same
> > problem?
> >
> > SELECT FIRST 1000 SKIP 10 * FROM SITETRANSACTION ORDER BY T_ADDED
> > ASCENDING
> >
> > Adam
>
> Yes, this statement worked in ISQL, so i guess its certainly a
> problem in my code and/or logic. I am using an IBOQuery component
> connected to an FB Database. Fairly standard setup i believe. Thanks
> for your assistance.
>
> Craig

I think this is a case of fighting IBO rather than cooperating with
it. Take a look at yesterdays answer from Lester Caine to a similar
question:
http://groups.yahoo.com/group/IBObjects/message/36230

I don't use IBOQueries, but if there is a OrderingItems property
available, I would recommend using that rather than putting it
directly in the SQL (particularly when you do not have a WHERE clause)
.

HTH,
Set