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