Icon View Incident Report

Minor Minor
Reported By: Roy Lambert
Reported On: 6/12/2009
For: Version 2.02 Build 14
# 3017 Extra Text After the Last END Block of an SQL Script Does Not Raise an Exception

If you have an extra (an inappropriate) END in a script any text after it is just ignored.

SCRIPT
BEGIN
EXECUTE IMMEDIATE 'CREATE TRIGGER "RemoveReadStatus"
AFTER DELETE ON "EMails"
BEGIN
....

END';

EXECUTE IMMEDIATE 'CREATE TRIGGER "PopNameChange"
BEFORE UPDATE OF "_PopBox" ON "PopBoxes"
BEGIN
....

END ';

END <<<<<<<<<<<<<< anything after this is ignored

-- Creating triggers for Career table

EXECUTE IMMEDIATE 'CREATE TRIGGER "CareerAfterUpdate"
AFTER UPDATE  ON "Career"
BEGIN



Resolution Resolution
Fixed Problem on 6/13/2009 in version 2.02 build 15


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