https://bz.apache.org/ooo/show_bug.cgi?id=127534
Issue ID: 127534
Issue Type: DEFECT
Summary: Compound primary keys of type TEXT with ODBC sqlite
database result in those columns always appearing
empty
Product: Base
Version: 4.1.3
Hardware: All
OS: Windows 10
Status: UNCONFIRMED
Severity: Major
Priority: P5 (lowest)
Component: code
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 86215
--> https://bz.apache.org/ooo/attachment.cgi?id=86215&action=edit
sqlite file, odb file, and two screenshots
I have several sqlite tables that have multiple TEXT columns as the primary key
(i.e., serving as a compound primary key). The ODBC connection using the sqlite
driver (http://www.ch-werner.de/sqliteodbc/) works fine: I can see and open all
my tables, add data, etc. I have foreign key constraints turned on in the ODBC
driver and they are properly enforced. However, after adding rows to a table,
then closing the table, and then reopening it, all of my (compound) primary key
fields (TEXT) appear blank. If I start to edit a row, then press Esc to about
the edit, then the data appears. This also applies to forms based on the
tables. Queries do not seem to suffer from this problem.
I've attached a zip file with the sqlite database (.db), the OObase file
(.odb), and a couple of screenshots.
--
You are receiving this mail because:
You are the assignee for the issue.
