Subject | Syntax Trouble |
---|---|
Author | Craig |
Post date | 2005-07-07T01:50:09Z |
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
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