OOo-3.4.1 breaks sqlite/ODBC: shows blank fields

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
JimB_oo
Posts: 2
Joined: Sat Mar 17, 2012 12:29 am

OOo-3.4.1 breaks sqlite/ODBC: shows blank fields

Post by JimB_oo »

I upgraded OpenOffice from 3.3 to 3.4.1, and it broke some of my databases.

I'm running sqlite3 via 32-bit ODBC on Win7x64.

I connect to the database just fine. But some of my tables and forms/sub-forms show empty fields where they shouldn't. It seems to involve tables that have text primary keys. This table, for instance:

CREATE TABLE Params
(
cfgKey TEXT PRIMARY KEY NOT NULL,
cfgVal TEXT NOT NULL
);

The table has five rows, and when I open it in OO I see five rows and cfgVal fields in the same order sqlite3 shows them. But all cfgKey fields are empty.

Another table that has an INTEGER AUTOINCREMENT primary key shows all its fields correctly.

I drop back to OOo-3.3.0 and everything works (just as before).
OpenOffice 3.3.0, PyUNO, Python 2.6, Win32
Post Reply