Changes between Version 14 and Version 15 of Docs/Prog/Manual/ApplicationLibraries/lib825mssql


Ignore:
Timestamp:
10/27/26 13:53:34 (4 days ago)
Author:
Don Wilson
Comment:

--

Legend:

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

    v14 v15  
    7474Microsoft SQL does not have the "LIMIT" clause that SQLite and MySQL have. This is commonly used for showing data in pages with "Next" and "Prev" buttons. The library has a new function AppendLimitClause to automatically append the correct syntax without having to use an if condition.
    7575
    76 {{{
     76{{{#!c++
    7777//char tmp[24];
    7878//snprintf(tmp, sizeof(tmp), " LIMIT %d,%d;", ((m_nCurPage - 1) * m_nItemsPerPage), m_nItemsPerPage);