What about "OFFSET" for paging? Does "TOP" have any support for that? If not, what is supported for paging via AcuXDBC?
AcuXDBC does not support the SQL LIMIT function.
MySQL has a LIMIT function which does what it implies. For example this returns only the first row:
SELECT * FROM MYTABLE LIMIT 1;
When doing this with AcuXDBC there is a syntax error reported.
AcuXDBC supports use of the TOP function to accomplish the same thing. This returns only the first row:
SELECT TOP 1 * FROM MYTABLE;