[Kexi] Kexi file and Sqlite3 ODBC driver

Noli Sicad nsicad at gmail.com
Thu Sep 2 09:19:27 CEST 2010


Hi,

It seems that kexi file could not be read by sqlite3 odbc driver.
However, it can be read / write by sqlite3 and spatialite in terminal
- CLI

See the error below
~~~~~~~~~~

>glpsol --cover --clique --gomory --mir -m "transp_sqlite3_kexi.mod"
GLPSOL: GLPK LP/MIP Solver, v4.44
Parameter(s) specified in the command line:
 --cover --clique --gomory --mir -m transp_sqlite3_kexi.mod
Reading model section from transp_sqlite3_kexi.mod...
Reading data section from transp_sqlite3_kexi.mod...
93 lines were read
Reading plants...
Connected to SQLite 3.6.22 - glpk.kexi
SELECT PLANT, CAPA AS CAPACITY FROM transp_capa
transp_sqlite3_kexi.mod:18: field PLANT missing in input table
MathProg model processing error
>Exit code: 1    Time: 0.042


Noli


More information about the Kexi mailing list