> 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 Help-glpk@gnu.org http://lists.gnu.org/mailman/listinfo/help-glpk