Re: -- insert instead of an update

"Andre" <avanrossem_at_hotmail.com> a écrit dans le message news: 4d32d1be.0311190134.7b49ac68_at_posting.google.com...
> Hello all,
>
> I want to do the following:
>
> If a record is updated I have made an before update trigger which is
triggered.
> What I want to do is, instead of an update, do an insert on the same
table.
>
> So modifying a record will insert an extra record in the table.
>
> Is this possible??
>
> Thanks for all comments,
> Andre The Netherlands

I forgot to tell about another possibility in my previous post. The use of an INSTEAD OF trigger. I rememberer after reading your post once again that
somebody told me he used it to transform delete to update. I 've never tested it on my own but if I've time today, i'll try it.

Cheers,
Alkos Received on Wed Nov 19 2003 - 05:03:46 CST