Reported By: Jeff Dunlop Reported On: 9/8/2010 For: Version 2.04 Build 2
# 3309Using a Scalar Sub-Query in an INSERT Statement Causes Parse Error Executing the following statement causes a #700 error.
EXECUTE IMMEDIATE 'INSERT INTO CustomerStatementTemplate VALUES ((SELECT COALESCE(MAX(TemplateID),0) + 1 FROM CustomerStatementTemplate),
''Customer Master Statement'',0,TRUE,
ResolutionFixed Problem on 9/11/2010 in version 2.04 build 3
Products AffectedElevateDB Additional Software and Utilities ElevateDB DAC Client-Server ElevateDB DAC Client-Server with Source ElevateDB DAC Standard ElevateDB DAC Standard with Source ElevateDB DAC Trial ElevateDB LCL Standard with Source ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial