Re: INSERT INTO on AFTER UPDATE trigger

[JK Heydt]

Thank you Peter,

Here is what I tried. I get red X's on the end if; and END rows at the bottom. No explanation as to why.

CREATE DEFINER = CURRENT_USER TRIGGER `hto_demo`.`field_AFTER_UPDATE` AFTER UPDATE ON `field` FOR EACH ROW
BEGIN
if new.FieldID<>old.FieldID then

INSERT INTO row_change
(RowID, TableCd, FieldID, ChangeDateTime, RecordCreatedBit , DataBefore,DataAfter,UserID)
select
new.RowID
,'FLD'
,'110'
,Getdate()
,0
,old.FieldID
,new.FieldID
,system_user()

end if;

END