Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need a SQL expert help : How to create a trigger for DELETE ???????

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

From: Peter Lancashire <Peter.Lancashire.PL1_at_bayer.co.uk>
Date: 1998/08/11
Message-ID: <35D078BF.25FB@bayer.co.uk>#1/1

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/
Received on Tue Aug 11 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US