Changes between Version 32 and Version 33 of Docs/Prog/Manual/ApplicationLibraries/lib825mssql


Ignore:
Timestamp:
11/18/26 16:02:00 (2 days ago)
Author:
Don Wilson
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Docs/Prog/Manual/ApplicationLibraries/lib825mssql

    v32 v33  
    7676}}}
    7777
    78 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 the "ORDER BY" clause immediately before this. This is also normally included for SQLite and MySQL. The library //lib825db// has a virtual function !AppendLimitClause to automatically append the correct limit clause syntax. For MySQL or SQLite this will append the " LIMIT <offset>,<count>" clause, for SQL Server this will append " OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY"
     78Microsoft 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 the "ORDER BY" clause immediately before this. This is also normally included for SQLite and MySQL.
     79
     80The library //lib825db// has a virtual function !AppendLimitClause to automatically append the correct limit clause syntax. For MySQL or SQLite this will append the " LIMIT <offset>,<count>" clause, for SQL Server this will append " OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY"
    7981
    8082{{{#!c++