Changes between Version 9 and Version 10 of Docs/Prog/Manual/ApplicationLibraries/lib825db

Timestamp:

10/23/25 07:14:17 (3 weeks ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825db

@@ -53 +53 @@
 }}}
 
+Existing apps with have sql execute statements such as:
+{{{
+int ct;
+string sql = "SELECT COUNT(*) FROM [Trucks];";
+db.execute(sql, ct);
+}}}
+
+Repace with:
+{{{
+int ct;
+string sql = "SELECT COUNT(*) FROM Trucks;";
+appDB->Execute(sql, ct);
+}}}
+To support both SQLite and MySQL the brackets must be removed from table and field names in SQL statements.