Changes between Version 17 and Version 18 of Docs/Prog/Manual/ApplicationLibraries/lib825mssql


Ignore:
Timestamp:
10/27/26 14:18:37 (4 days ago)
Author:
Don Wilson
Comment:

--

Legend:

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

    v17 v18  
    7575
    7676{{{#!c++
    77 //char tmp[24];
    78 //snprintf(tmp, sizeof(tmp), " LIMIT %d,%d;", ((m_nCurPage - 1) * m_nItemsPerPage), m_nItemsPerPage);
     77// For SQLite or MySQL AppendLimitClause will append " LIMIT offset, count"
     78// For SQL Server AppendLimitClause will append " OFFSET offset ROWS FETCH NEXT count ROWS ONLY"
    7979//strSQL_ += tmp;
    8080appDB->AppendLimitClause(strSQL_, ((m_nCurPage - 1) * m_nItemsPerPage), m_nItemsPerPage);