Re: [Help-glpk] Re: changes in sql table driver

[glpk xypron]

Hello Andrew,

I will provide a patch within the next week.

Best regards

Xypron
-------- Original-Nachricht --------
> Datum: Thu, 5 Nov 2009 23:17:25 +0300
> Von: Andrew Makhorin
> An: address@hidden
> Betreff: [Help-glpk] Re: changes in sql table driver

> > Is it possible to make changes in the sql table driver in order to
> > concatenate some arguments (marked in some way) to construct the
> > resulting sql statement?
> 
> Something like this, where a trailing backslash (or any other
> appropriate character) in the symbolic value means concatenation:
> 
> table investmentTable {(fe, oe, ift, it) in investmentEntity,
>    p in periodFlow, scen in scenario} OUT odbcDriver odbcConnectString
>       "UPDATE tModInvestmentPeriodSet SET \"
>       "tModInvestmentPeriodSet.openingBalanceVar = ?, \"
>       "tModInvestmentPeriodSet.investmentFromToVar = ?, \"
>       "tModInvestmentPeriodSet.investmentCapitalGainVar = ?, \"
>       "tModInvestmentPeriodSet.investmentDividendsVar = ?, \"
>       "tModInvestmentPeriodSet.investmentInterestVar = ?, \"
>       "tModInvestmentPeriodSet.investmentGrowthVar = ?, \"
>       "tModInvestmentPeriodSet.closingBalanceVar = ?  \"
>       "WHERE  tModInvestmentPeriodSet.scenarioId = ? AND \"
>              "tModInvestmentPeriodSet.fundEntityId = ? AND \"
>              "tModInvestmentPeriodSet.investmentTypeId = ? AND \"
>              "tModInvestmentPeriodSet.periodId = ?" :
>       investmentEntityBalance[fe, oe, ift, it, p],
>       invFromToAmount[fe, oe, ift, it, p],
>       investmentCapitalGain[fe, oe, ift, it, p],
>       investmentReturn[fe, oe, ift, it, "DividendEligible", p],
>       investmentReturn[fe, oe, ift, it, "Interest", p],
>       investmentReturn[fe, oe, ift, it, "Growth", p],
>       investmentEntityBalance[fe, oe, ift, it, p+1],
>       pValue[scen], fe, ift, p;
> 
> 
> 
> 
> 
> _______________________________________________
> Help-glpk mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/help-glpk

-- 
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser