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

Timestamp:

10/23/25 07:42:23 (3 weeks ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825db

@@ -52 +52 @@
 }
 }}}
+This instantiates either a CDBMySQL object for MySQL or a CDBSQLite. The CDB* pointer appDB is assigned to the created object.
 
 Existing apps with have sql execute statements such as:
@@ -67 +68 @@
 }}}
 To support both SQLite and MySQL the brackets must be removed from table and field names in SQL statements.
+
+Existing apps may have code such as:
+{{{
+string sql = "INSERT INTO [Trucks] ([ID],[TareWt]) VALUES ('" + truckID +"'," + IntToStr(tare) + ");"; 
+if (rc_is_okay(db.execute(sql)) == false) {
+   DrawErrorBox("Cannot insert record", 4);
+}
+}}}
+Replace with:
+{{{
+string sql = "INSERT INTO Trucks (ID,TareWt) VALUES ('" + truckID +"'," + IntToStr(tare) + ");"; 
+if (appDB->execute(sql) == false) {
+   DrawErrorBox("Cannot insert record", 4);
+}
+}}}
 
 Existing apps will have code such as: