Hi,

>> SELECT FIRST 1000 SKIP 10 * FROM SITETRANSACTION ORDER BY T_ADDED
>> ASCENDING
>
> 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.

May be IBO try to add a RDB$DB_KEY to the query, what if you give the table an alias.

SELECT
FIRST 1000 SKIP 10
t.*
FROM
SITETRANSACTION t
ORDER BY
t.T_ADDED ASCENDING

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database developer support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features:
http://www.firebirdsql.org
http://www.firebirdsql.info

Support list for Interbase and Firebird users:
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep:
news://newsgroups.firebirdsql.info