[Help-glpk] SQL query as input table - MathProg

[Noli Sicad]

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