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

Timestamp:

01/20/26 11:00:23 (2 weeks ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825db

@@ -139 +139 @@
 }
 }}}
+
+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"
+                ");";
+
+        // if (!rc_is_okay(db.execute(zTrans)))
+        if(appDB->Execute(/*zTrans*/ sql) == false) {
+                DrawErrorBox("Error creating transaction table", 2);
+        }
+
+}}}
+