Because
Joe Wilson <[EMAIL PROTECTED]> writes:
> Hello Jarl,
>
> I would be interested in seeing the answers to your ODBC
> driver questions, as well as Christian Werner's opinion of your
> patch, if it is no trouble for you.
>
> Thanks.
>
I will forward Christians answer, and I suggest the discussion
continues on this list until someone actually complains that the topic
does not belong on the list.
--- Begin Message ---
Jarl Friis wrote:
> 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.
I think discussion of that specific driver does not belong on
the SQLite list, thus I reply to you privately.
> 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".
What exactly is wrong with the current implementation ? The purpose of
the code following the "if (!doautoinc)" expression is the detection
of columns with autoincrement behaviour. If I understand the SQLite
documentation correct, the only way to create an autoincrement column
is "columnname INTEGER PRIMARY KEY AUTOINCREMENT"
(from http://www.sqlite.org/autoinc.html).
Please let me know a) the SQL you used to create an autoinc column which
b) is not detected by the current implementation, and c) which SELECTs
failed with the current implementation.
> 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?
To be able to implement SQLColumnAttribute(...SQL_DESC_TABLE_NAME...)
efficiently.
Regards,
Christian
--- End Message ---
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
