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

[Andrew Makhorin]

> 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.
> 

This error may mean that the table tblYield has some records with
duplicate fields Croptype=OTD, Age=1, Product=CFREV. Check that.