Subject | What's wrong with my Aft-Del-Trigger, can't create it in FB2 |
---|---|
Author | Bhavbhuti Nathwani |
Post date | 2007-01-01T06:38:09Z |
Hi all
Wishing you all a Very Happy New Year!!!
I am trying to create a After Delete Trigger using FlameRobin 0.7.6
but I cannot seem to be able to create the trigger. I keep getting
the following error:
Message: isc_dsql_prepare failed
SQL Message : -104
Invalid token
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 10, column 37
;
My code is as follows:
SET TERMINATOR ^ ;
CREATE TRIGGER trg_aft_del_spackinglist_ustok FOR SPACKINGLIST
ACTIVE AFTER DELETE POSITION 0
AS
BEGIN
-- DELETE FROM uStock
-- WHERE iPID = Old.iID;
SELECT * FROM DelUStock(Old.iID);
END^
SET TERMINATOR ; ^
I have successfully create the stored procedure DelUStock().
Please help.
Wishing you all a Very Happy New Year!!!
I am trying to create a After Delete Trigger using FlameRobin 0.7.6
but I cannot seem to be able to create the trigger. I keep getting
the following error:
Message: isc_dsql_prepare failed
SQL Message : -104
Invalid token
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 10, column 37
;
My code is as follows:
SET TERMINATOR ^ ;
CREATE TRIGGER trg_aft_del_spackinglist_ustok FOR SPACKINGLIST
ACTIVE AFTER DELETE POSITION 0
AS
BEGIN
-- DELETE FROM uStock
-- WHERE iPID = Old.iID;
SELECT * FROM DelUStock(Old.iID);
END^
SET TERMINATOR ; ^
I have successfully create the stored procedure DelUStock().
Please help.