Sorry for being OT, but I could not find a better place. I think when SQLite ODBC driver postings are very low-frequent, it wouldn't hurt to (ab)use this list for that.
Christian Werner <[EMAIL PROTECTED]> writes: > Version 0.66 of the SQLite ODBC Driver is available > on http://www.ch-werner.de/sqliteodbc > It supports now SQLite 3.3.4 and 2.8.17. Dear Christian. I have fixed a bug in the SQLite ODBC driver. The problem is that the ODBC driver does not use the info from "PRAGMA table_info(...)" when there are no columns declared as "integer". Further I wonder what's behind the decision to use PRAGMA short_column_names = off PRAGMA full_column_names = on When using short_column_names instead (which is default), behaviour seems closer to standard Database SQL engines. Could you ellaborate on this decision?
Index: sqlite3odbc.c =================================================================== --- sqlite3odbc.c +++ sqlite3odbc.c @@ -1157,9 +1157,6 @@ s->dyncols[i].autoinc = 0; } } - if (!doautoinc) { - return; - } if (s->dcols > array_size(flags)) { flagp = xmalloc(sizeof (flags[0]) * s->dcols); if (flagp == NULL) { @@ -1170,9 +1167,6 @@ } memset(flagp, 0, sizeof (flags[0]) * s->dcols); for (i = 0; i < s->dcols; i++) { - s->dyncols[i].autoinc = 0; - } - for (i = 0; i < s->dcols; i++) { int ret, lastpk = -1, autoinccount = 0; char *sql;
Jarl -- Jarl Friis Softace ApS Omøgade 8, 2.sal 2100 København Ø. Denmark Phone: +45 26 13 20 90 E-mail: [EMAIL PROTECTED] LinkedIn: https://www.linkedin.com/in/jarlfriis