Re: Need a SQL expert help : How to create a trigger for DELETE ???????

Eric, Chow Hoi Ka wrote:
>
> Hello,
>
> How can I create a TRIGGER for DELETE a record ?
>
> Such as, when I delete a record, it will auto copy this record to
> another TABLE ???

I do not know about the other database you have posted to, but this can absolutely be done in Informix. You can do it with a simple delete trigger or, if more complex processing is required, you can call a stored procedure from the trigger.

Art S. Kagel Received on Tue Aug 11 1998 - 00:00:00 CDT