Changes between Version 44 and Version 45 of Docs/Prog/Manual/ApplicationLibraries/lib825db

Timestamp:

01/20/26 11:02:17 (2 weeks ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825db

@@ -142 +142 @@
 The following example shows creating a table with PRIMARY KEY AUTO_INCREMENT the keyword is AUTO_INCREMENT in MySQL and AUTOINCREMENT in SQLite.
 {{{#!c++
-        string sql;
-        sql = "CREATE TABLE IF NOT EXISTS trans (";
-        if(dynamic_cast<CDBMySQL*>(appDB)) {
-                sql +=  "id INTEGER PRIMARY KEY AUTO_INCREMENT,";
-        } else {
-                sql +=  "id INTEGER PRIMARY KEY AUTOINCREMENT,";
-        }
-        //sql +=        "trans_time VARCHAR(16),"               // Time in
-        //              "trans_date VARCHAR(16),"               // Date in
-        sql +=  "datetm DATETIME, "
-                        "cost VARCHAR(16),"                             // amount of this transaction
-                        "pmt_type VARCHAR(50),"                 // "ID Card", "Credit Card", "Code/Reweigh"
-                        "badge VARCHAR(20),"                    // Badge ID (if CREDIT)
-                        "customer VARCHAR(20),"                 // The customer name (if CREDIT)
-                        "truck VARCHAR(20),"                            // Company Truck ID if provided
-                        "mileage INT,"
-                        "gross REAL,"
-                        "gross2 REAL,"
-                        "gross3 REAL,"
-                        "gross4 REAL,"
-                        "grossT REAL," // Total wt (sum of wts)
-                        "axles INT,"
-                        "code TEXT,"
-                        "codeexpires INT"
-                ");";
+string sql;
+sql = "CREATE TABLE IF NOT EXISTS trans (";
+if(dynamic_cast<CDBMySQL*>(appDB)) {
+  sql += "id INTEGER PRIMARY KEY AUTO_INCREMENT,";
+} else {
+  sql += "id INTEGER PRIMARY KEY AUTOINCREMENT,";
+}
+sql +=  "datetm DATETIME, "
+        "cost VARCHAR(16),"
+        "pmt_type VARCHAR(50),"
+        "badge VARCHAR(20),"
+        "customer VARCHAR(20),"
+        "truck VARCHAR(20),"
+        "mileage INT,"
+        "gross REAL,"
+        "gross2 REAL,"
+        "gross3 REAL,"
+        "gross4 REAL,"
+        "grossT REAL,"
+        "axles INT,"
+        "code TEXT,"
+        "codeexpires INT"
+");";
 
-        // if (!rc_is_okay(db.execute(zTrans)))
-        if(appDB->Execute(/*zTrans*/ sql) == false) {
-                DrawErrorBox("Error creating transaction table", 2);
-        }
-
+if(appDB->Execute(sql) == false) {
+  DrawErrorBox("Error creating transaction table", 2);
+}
 }}}