Changes between Version 10 and Version 11 of Docs/Prog/Manual/ApplicationLibraries/lib825db

Timestamp:

10/23/25 07:19:38 (3 weeks ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825db

@@ -67 +67 @@
 }}}
 To support both SQLite and MySQL the brackets must be removed from table and field names in SQL statements.
+
+Existing apps will have code such as:
+{{{
+string sql = "SELECT * FROM [railcars] WHERE [ID] = '" + strId + "';";
+statement st(db, sql);
+cursor cur(st.get_cursor());
+if(cur.step() == SQLITE_ROW) {
+   cur.get("ID", curRailcar.strId);
+   cur.get("Target", curRailcar.target);
+}
+}}}
+
+Replace with:
+Existing apps will have code such as:
+{{{
+string sql = "SELECT * FROM railcars WHERE ID = '" + strId + "';";
+CDBStatement stmt(appDB, sql);
+if(stmt.Step() == DBSQL_ROW) {
+   stmt.Get("ID", curRailcar.strId);
+   stmt.Get("Target", curRailcar.target);
+}
+}}}
+
+