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 _______________________________________________ Help-glpk mailing list [email protected] https://lists.gnu.org/mailman/listinfo/help-glpk
