Trigger in TDM for MySQL

Toad Data Modeler
1

Hello,

Could you please help me to create Triggers in TDM for MySQL.

  1. I tried creating After Update Trigger in TDM as below, but I am getting error if I execute this in MySQL.

After Update Trigger:

BEGIN

UPDATE customer_wname SET whole_name=CONCAT(NEW.first_name,’ ‘,NEW.last_name,’ ',NEW.middle_name) WHERE id=NEW.id;

END;

  1. It would be great if someone shares me the instructions on how to use the “Insert Template” and “Open Template Editor” which is available in Trigger properties–>Under SQL tab.

Thanks !!

2

if you go into HELP and search for ‘template editor’ this may answer your questions.

-Mark