[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL s
From: |
Andrew Makhorin |
Subject: |
Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg |
Date: |
Fri, 12 Feb 2010 02:35:39 +0300 |
> 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')
- [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg, Noli Sicad, 2010/02/11
- [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg, Noli Sicad, 2010/02/11
- Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg,
Andrew Makhorin <=
- Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg, Noli Sicad, 2010/02/11
- Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg, Noli Sicad, 2010/02/11
- Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg, Noli Sicad, 2010/02/12
- Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg, Andrew Makhorin, 2010/02/12
- Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg, Noli Sicad, 2010/02/12
- Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg, Andrew Makhorin, 2010/02/12
Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg, Andrew Makhorin, 2010/02/11