[Kexi] Kexi file and Sqlite3 ODBC driver

[Jaroslaw Staniek]

On 2 September 2010 09:19, Noli Sicad <nsicad at gmail.com> wrote:
> 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

Hi Noli,
Is the 'field PLANT missing in input table' error related to Kexi at all?
Kexi uses unpatched sqlite3 that is present in your operating system.

-- 
regards / pozdrawiam, Jaroslaw Staniek
 http://www.linkedin.com/in/jstaniek
 Kexi & KOffice (http://www.kexi-project.org, http://www.koffice.org)
 KDE Software Development Platform on MS Windows (http://windows.kde.org)