Re: [Help-glpk] MySQL Support for GLPK 4.23

[glpk xypron]

Hi Andrew,

I have analyzed what AMPL does with table statements (see below).

All my needs concerning database connectivity could be fulfilled by table 
statements in the AMPL syntax.

Guess it will take 80 h to implement.

I will give it a try.

Best regards

Xypron

-------------------------------------------------

If a table is defined as OUT, the existing table is dropped and a new table 
created.

If a table is defined as INOUT, missing columns and rows (defined by the key 
columns) are added.

The following example (working in AMPL) shows how new results can be added to a 
table in each calculation run.

set SIMOLD;
set SIMV := setof{ j in SIMOLD }(j + 1);

table simvers IN "ODBC" "TABLES/diet.mdb" 
   "SQL=SELECT max(SimV) AS A FROM results" :
   SIMOLD <- [A];

table res INOUT "ODBC" "TABLES/diet.mdb" "results": 
   {n in SIMV, j in FOOD : j in { 'PORK', 'BEEF' } } -> 
   [n ~ SimV, j ~ FOOD],
   Buy[j] ~ Buy OUT, Buy.rc[j] ~ BuyRC OUT,  
   Buy[j]/f_max[j] ~ BuyFrac OUT;

read table simvers;
solve;
write table res;

> -------- Original-Nachricht --------
> > Datum: Sat, 3 Nov 2007 14:48:54 +0300
> > Von: Andrew Makhorin <address@hidden>
> > An: address@hidden
> > CC: address@hidden
> > Betreff: Re: [Help-glpk] MySQL Support for GLPK 4.23
> 
> > 
> > How difficult to provide compatibility with a similar feature existing
> > in AMPL? Please see http://www.ampl.com/NEW/tables.html .
> > 
> > 
> > 
> 
> -- 
> GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
> Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
> 
> 
> _______________________________________________
> Help-glpk mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/help-glpk

-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger