Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread SCRIPT - END
Fri, Jun 12 2009 5:34 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Dunno if this would be regarded as a bug or not. If you have an extra (an inappropriate) END in a script any text after it is just ignored eg


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


Roy Lambert
Fri, Jun 12 2009 1:29 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Dunno if this would be regarded as a bug or not. If you have an extra (an
inappropriate) END in a script any text after it is just ignored eg >>

I'll check it out.  It should probably raise an exception.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image