OOo-3.4.1 breaks sqlite/ODBC: shows blank fields

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

OOo-3.4.1 breaks sqlite/ODBC: shows blank fields

Postby JimB_oo » Thu Oct 18, 2012 10:09 pm

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
JimB_oo
 
Posts: 2
Joined: Sat Mar 17, 2012 12:29 am

Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests