Changes between Version 24 and Version 25 of Docs/Prog/Manual/ApplicationLibraries/lib825mssql

Timestamp:

10/28/26 07:11:38 (3 days ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825mssql

@@ -72 +72 @@
 }}}
 
-Microsoft SQL does not have the "LIMIT" clause that SQLite and MySQL have. This clause is commonly used for showing data in pages with "Next" and "Prev" buttons. Microsoft SQL 2012 and above have "OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY" that achieves the same function. (Microsft SQL requires "ORDER BY" clause immediately before this. The library has a new function !AppendLimitClause to automatically append the correct syntax without having to use an if condition.
+Microsoft SQL does not have the "LIMIT" clause that SQLite and MySQL have. This clause is commonly used for showing data in pages with "Next" and "Prev" buttons. Microsoft SQL 2012 and above have "OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY" that achieves the same function. (Microsft SQL requires "ORDER BY" clause immediately before this. The library //lib825db// has a virtual function !AppendLimitClause to automatically append the limit clause. For MySQL or SQL this will append the "LIMIT <offset>,<count>" clause, for SQL Server this will append "OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY"
 
 {{{#!c++