On 2 September 2010 09:19, Noli Sicad <[email protected]> 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) _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
