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


Reply via email to