Enhancement Request to add Before and After Scripts for Triggers i.e. "delimiter //" in Toad Data Modeler. I would like to add the “Before Script” and “After Script” option or tabs for Triggers too. As of now, these are available for Procedures, Functions, but not for Triggers.
Example:
DROP TRIGGER TRG_ADDRESS_AINS;
delimiter //
CREATE TRIGGER TRG_ADDRESS_AINS AFTER INSERT
ON address
FOR EACH ROW
BEGIN
INSERT INTO Address_aud (Address_UID, Address_Type_UID, State_Province_UID, Country_Code_UID, Users_UID, Company_UID, Address1, Address2, City, County, Zip_Code, Validation_Status, Create_Modified_By, Create_Modified_Date, Operation, District_UID)
VALUES (NEW.Address_UID, NEW.Address_Type_UID, NEW.State_Province_UID, NEW.Country_Code_UID, NEW.Users_UID, NEW.Company_UID, NEW.Address1, NEW.Address2, NEW.City, NEW.County, NEW.Zip_Code, NEW.Validation_Status, NEW.Create_Modified_By,NEW.Create_Modified_Date, 'Insert', NEW.District_UID);
END
; //
delimiter ;
WORKAROUND:
None
STATUS:
Enhancement request ST88399 has been submitted to Development for consideration in a future release of Toad Data Modeler.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center