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

Timestamp:

10/27/26 13:52:18 (4 days ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825mssql

@@ -71 +71 @@
 }
 }}}
+
+Microsoft 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.
+
+{{{
+//char tmp[24];
+//snprintf(tmp, sizeof(tmp), " LIMIT %d,%d;", ((m_nCurPage - 1) * m_nItemsPerPage), m_nItemsPerPage);
+//strSQL_ += tmp;
+appDB->AppendLimitClause(strSQL_, ((m_nCurPage - 1) * m_nItemsPerPage), m_nItemsPerPage);
+strSQL_ += ";"; 
+}}}