Page 1 of 1

ODBC sqlite3 memo/text as primary key does not work

PostPosted: Thu Nov 15, 2018 12:42 am
by qoreQyaS
Hello community,

I'am trying to use an existing sqlite3 Database with the ODBC driver provided by http://ch-werner.de/sqliteodbc/ on a windows 10 machine with apache openoffice 4.1.5.
After some trial and error i'am able to see the tables in the table view, also the data in the tables can be seen.
The data in fields which use text or memo as primary key is not shown.

I also tried creating a new sqlite3 database and populate it from within OpenOffice with the same result: after reopening the table all the primary key fields are empty.

Any hints? May this be a bug?

Using the same ODBC source with SqlDbx shows the data.

best regards

Re: ODBC sqlite3 memo/text as primary key does not work

PostPosted: Thu Nov 15, 2018 4:53 pm
by Villeroy

Re: ODBC sqlite3 memo/text as primary key does not work

PostPosted: Thu Nov 15, 2018 6:13 pm
by qoreQyaS
Where does it say that?
In the tutorial you posted every example uses integer as primary key but it doesn't say it is not allowed to use anything else.
https://www.sqlite.org/lang_createtable.html
If a table has a single column primary key and the declared type of that column is "INTEGER" and...

This sentence wouldn't make sense if it is not allowed to use anything else as integer.