Re: before delete trigger to make backup of deleted data

[John Simons]

Thanks. Typo on my part here. But what syntax can I use for the "values" part of the insert to ensure I insert the appropriate deleted row information?

create trigger hellox before delete on hello
for each row
insert into hello_deleted_data (x,y,z)
values (???.x, ???.y, ???.z); <-- ??

Thanks VERY much!
John



Edited 3 time(s). Last edit at 05/10/2006 02:56PM by John Simons.