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 ??? > > Best regards, > Eric Before going to the trouble of answering this, could you confirm that you want to do it in Informix and not any of the other databases whose newsgroups you have also posted? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/