-- insert instead of an update

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 Received on Wed Nov 19 2003 - 03:34:48 CST