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