#LSNumberFormat(_monthIdx, "00")# #_yearIdx# SELECT #getQueryString()# WHERE projectSalesPlan.idProjectSalesPlan= SELECT #getQueryString()# WHERE projectSalesPlan.idProject= ORDER BY #arguments.orderBy##module.list.orderBy# SELECT idProjectSalesPlan FROM projectSalesPlan WHERE idProject= AND datePeriod= AND idProjectSalesPlan != INSERT INTO projectSalesPlan ( idProjectSalesPlan, idProject, idCurrency, datePeriod, numberOfUnits, amount ) VALUES ( , , , , , ) ON DUPLICATE KEY UPDATE idCurrency=, numberOfUnits=, amount= Details: " & cfcatch.Detail> UPDATE projectSalesPlan SET idCurrency=, datePeriod=, numberOfUnits=, amount= WHERE idProjectSalesPlan= Details: " & cfcatch.Detail> DELETE FROM projectSalesPlan WHERE idProjectSalesPlan= Details: " & cfcatch.Detail> #UCase(LSDateFormat(list.datePeriod, "MMM"))# #LSDateFormat(list.datePeriod, "yyyy")#