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

Timestamp:

10/27/26 13:27:52 (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.
 
-A common SQL statement for 825 projects is "CREATE TABLE IF NOT EXISTS" for startup code. Microsoft SQL Server does not support this. The "IF OBJECT_ID('tblname', 'U') IS NULL BEGIN CREATE TABLE" may be used instead. The "INTEGER PRIMARY KEY AUTO_INCREMENT" also will need to be handled differently.
+A common SQL statement in startup code for 825 projects is "CREATE TABLE IF NOT EXISTS". Microsoft SQL Server does not support this. The "IF OBJECT_ID('tblname', 'U') IS NULL BEGIN CREATE TABLE" may be used instead. This statement initiates a "BEGIN" which must be terminated after the create with "END". 
+
+The "INTEGER PRIMARY KEY AUTO_INCREMENT" also will need to be handled differently. Replace this with "INTEGER IDENTITY(1,1) PRIMARY KEY".
 
 {{{#!c++