Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg

[Andrew Makhorin]

> However, when converted
> the 3 models into CPLEX format, the 3 models are exactly the same,
> just ordering of the variables and constraints
>  (see converted models below).

Not the same.

> \* Problem: transp_odbc_sqlite3 *\

> Minimize
>  cost: + 0.225 x(Seattle,'New_York') + 0.153 x(Seattle,Chicago)
>  + 0.162 x(Seattle,Topeka) + 0.225 x('San_Diego','New_York')
>  + 0.162 x('San_Diego',Chicago) + 0.126 x('San_Diego',Topeka)

> \* Problem: transp_odbc_xls *\
> Minimize
>  cost: + 0.225 x('San_Diego',Chicago) + 0.162 x('San_Diego','New_York')
>  + 0.126 x('San_Diego',Topeka) + 0.153 x(Seattle,Chicago)
>  + 0.225 x(Seattle,'New_York') + 0.162 x(Seattle,Topeka)

transp_odbc_sqlite3:
0.225 x('San_Diego','New_York')

transp_odbc_xls:
0.162 x('San_Diego','New_York')