ODBC sqlite3 memo/text as primary key does not work

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
qoreQyaS
Posts: 2
Joined: Thu Nov 15, 2018 12:31 am

ODBC sqlite3 memo/text as primary key does not work

Post 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
Apache OpenOffice 4.1.5 / Windows 10
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
qoreQyaS
Posts: 2
Joined: Thu Nov 15, 2018 12:31 am

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

Post 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.
Apache OpenOffice 4.1.5 / Windows 10
Post Reply