Changes between Version 7 and Version 8 of Docs/Prog/Manual/ApplicationLibraries/lib825mssql

Timestamp:

10/27/26 13:19:26 (4 days ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825mssql

@@ -32 +32 @@
 This instantiates a CDBMySQL object for MySQL, a CDBMSSQL object for SQL Server, or a CDBSQLite object for SQLite based on the configuration. The created object is assigned to the pointer CDB* appDB.
 
+{{{#!c++
+        if(dynamic_cast<CDBMSSQL*>(appDB)) {
+                sql = "IF OBJECT_ID('dbo.axleTrans', 'U') IS NULL BEGIN CREATE TABLE axleTrans (";
+        } else {
+                sql = "CREATE TABLE IF NOT EXISTS axleTrans (";
+        }
+
+                        if(dynamic_cast<CDBMySQL*>(appDB)) {
+                                sql +=  "id INTEGER PRIMARY KEY AUTO_INCREMENT,";
+                        } else if(dynamic_cast<CDBMSSQL*>(appDB)) {
+                                sql += "id INTEGER IDENTITY(1,1) PRIMARY KEY,";
+                        } else {
+                                sql += "id INTEGER PRIMARY KEY,"; // SQLite: INTEGER PRIMARY KEY aliases ROWID and auto-increments
+                        }
+                        sql +=
+                                "cost TEXT," // amount of this transaction
+                                "pmt_type TEXT," // CASH if cash, else CREDIT if Account customer
+                                "badge TEXT," // Badge ID (if CREDIT)
+                                "customer TEXT,"; // The customer name (if CREDIT)
+
+                        for(n = 0; n < MAX_DB_AXLES; n++) {
+                                sql += "axle" + to_string(n + 1) + " REAL,";
+                        }
+
+                        sql += "grossT REAL" // Total wt (sum of wts)
+                                ",datetm DATETIME"
+                                ");";
+        if(dynamic_cast<CDBMSSQL*>(appDB)) {
+                sql += " END";
+        }
+
+                if(appDB->Execute(sql) == false) {
+                        DrawErrorBox("Error creating transaction table", 2);
+                }
+
+}}}