Hi Xypron, Would it be possible to use SQL query statement as input in Table?
If yes, what is wrong with this script. set S2, dimen 2; table tab IN "ODBC" 'Driver=SQLITE3;Database=Otago_p.sqlite;' 'SELECT tblCroptype.Croptype, tblData.Age tblData.Area' 'FROM tblCroptype JOIN tblData ON tblData.Croptype = tblCroptype.Croptype': S2 <- [tblCroptype.Croptype, tblData.Age], Area ~ tblData.Area # S2 <- [Croptype ~ tblCroptype.Croptype, Age ~ tblData.Age], Area ~ tblData.Area Error. GLPSOL: GLPK LP/MIP Solver, v4.44 Parameter(s) specified in the command line: --cover --clique --gomory --mir -m EstateModel_sqlite3_1.mod Reading model section from EstateModel_sqlite3_1.mod... EstateModel_sqlite3_1.mod:128: display not defined Context: ...2 , dimen 2 ; table tab IN '...' '...' '...' '...' : display MathProg model processing error >Exit code: 1 Time: 0.129 Regards, Noli _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
