Icon View Incident Report

Serious Serious
Reported By: Jeff Dunlop
Reported On: 9/8/2010
For: Version 2.04 Build 2
# 3309 Using 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,




Resolution Resolution
Fixed Problem on 9/11/2010 in version 2.04 build 3


Products Affected Products Affected
ElevateDB 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

Image