[Help-glpk] 3 (Triple indexes) [a, b, c] in iODBC Tables in MathProg problem

[Noli Sicad]

Hi Xypron and List,

I got a problem using triple indexes (e.g. 'tblYield' : [Croptype,
Age, Product], Yield; )

I am using SQLite3 in Mac OS X with iODBC. I am trying to move my
regular tables in SQLite3/Spatialite.

#########

table Yield1 IN "ODBC" 'DRIVER=SQLite3
Driver;Database=/Users/nsicad/Documents/DISK1S1_bak/ForestryLP/Otago.sqlite;'
'tblYield' : [Croptype, Age, Product], Yield;
#display Yield;

#########

I got this error.

#########
Reading Yields....
Reading Yield11...
Connected to SQLite 3.7.6.2 -
/Users/nsicad/Documents/DISK1S1_bak/ForestryLP/Otago.sqlite
SELECT Croptype, Age, Product, Yield FROM tblYield
ForestValue_r71_sqlite_6.mod:264: Yield[OTD,1,CFREV] already defined
MathProg model processing error
#########

Do you fix this problem?

I don't have problem with 1 or 2 indexes. This one has no problem.

#############

table Area11 IN "ODBC" 'DRIVER=SQLite3
Driver;Database=/Users/nsicad/Documents/DISK1S1_bak/ForestryLP/Otago.sqlite;'
'tblData' : [Croptype, Age], Area ~ Area;
display Area;

###########

Thanks.

Noli