Toad World® Forums

Script example for creating triggers


#1

Hi,

Do You have some example script that for new table (created in TDM) create triggers ( AFTER / BEFORE INSERT) with complete set of properties from “General” tab. In SQL tab scrip should to insert “Old” row contens ?

The best soluion will be if this script runs from Button on “Triggers” tab of Entity Properties form.

Thak You for Your help,

Adam


#2

Properties to triggers can be found under object PERTriggerEntityABBREV.

ABBREV is e.g. for Oracle OR, MY is for MySQL, MS is for MSSQL.

Hi Adam,

Please find attached an example of script that creates a trigger (with different names) in all entities. The script is for MySQL database.
It should be executed in Scripting Window (Tools menu, Expert mode on).

To modify it, please have a look at the Reference Guide (Help menu).

If you need any help, please do not hesitate to write us. Just write details on what you need and expect and we will help.

Regarding adding the button, you may have a look at the Manual, Customization chapter + visit our weblog:
http://blogs.inside.quest.com/modeling/category/customize/

If you have any questions, please write us back. Thanks.

Regards,

Vladka + TDM Team
CreateTrigger.zip (605 Bytes)


#3

Hi,

Thank You very much.
It work’s.

Best regards,

Adam