ODBC sqlite3 memo/text as primary key does not work

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

ODBC sqlite3 memo/text as primary key does not work

Postby qoreQyaS » Thu Nov 15, 2018 12:42 am

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
qoreQyaS
 
Posts: 2
Joined: Thu Nov 15, 2018 12:31 am

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

Postby Villeroy » Thu Nov 15, 2018 4:53 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26392
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby qoreQyaS » Thu Nov 15, 2018 6:13 pm

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
qoreQyaS
 
Posts: 2
Joined: Thu Nov 15, 2018 12:31 am


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests