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

[Andrew Makhorin]

> 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;