Subject What's wrong with my Aft-Del-Trigger, can't create it in FB2
Author Bhavbhuti Nathwani
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.