Icon View Incident Report

Serious Serious
Reported By: Clive
Reported On: 7/28/2004
For: Version 4.09 Build 1
# 1795 SQL UPDATE Statements With Joins Causing Parse Error

update "\memory\exp"
set value = coalesce(value,0.0) + coalesce(sed.value,0.0)
from "\memory\exp"
inner join scenario_expense_detail sed on sed.project_code =
exp.project_code and sed.period = exp.period and sed.expenses_code =
exp.expenses_code and sed.scenario_code = exp.scenario_code

Produces this error

DBISAM Engine Error # 11949 SQL parsing error - Expected UPDATE table name
but instead found "\memory\exp" in UPDATE SQL statement at line 1, column 87

update "\memory\exp"
set value = coalesce(value,0.0) + coalesce(sed.value,0.0)
from "\memory\exp"
inner join scenario_expense_detail sed on  sed.project_code =
exp.project_code and  sed.period = exp.period and  sed.expenses_code 
=
exp.expenses_code and sed.scenario_code = exp.scenario_code



Resolution Resolution
Fixed Problem on 7/28/2004 in version 4.10 build 1
Image