[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Help-glpk] Re: changes in sql table driver
From: |
Andrew Makhorin |
Subject: |
[Help-glpk] Re: changes in sql table driver |
Date: |
Thu, 5 Nov 2009 23:17:25 +0300 |
> 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;