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