Subject | Re: Insert Trigger which makes an Update if pk allready there possible? |
---|---|
Author | kaczy27 |
Post date | 2004-08-20T14:48:08Z |
>trigger
> No, a trigger acts as part of a specific operation (I/U/D) so a
> can't change the operation to be "insert" if it was "update" orto "update"
> if it was "insert". All you could do here would be to have aroutine to
> create a different value for the PK and thus prevent the keyis it possible to stop execution of the operation in the 'before
> violation; but this isn't what you want here.
trigger' that is part of this operation?
this is done by exception throwing, correct?
I am doing updates in triggers, so it is possible to update a record
and then throw exception. The exception had to be handled though. or
the exception force the rollback of the transaction? maybe then
commit before throwing an exception?
Or to avoid an exceptions throwing setup a dummy key (say of a value
less then 1000 and greater than existing dummy records values) and
delete all records from keys range 1-1000 as a part of 'after
trigger'.
I agree that a stored procedure is more elegant, but still it is
possible to do it via trigger, am I right?
a question by the way are transactions flat or hierarchical - ie. if
I aopen a transaction from within another transaction and commit the
inside one, will it be rolled back if I recall the outside
transaction?
>CUIN Kaczy
>
> /heLen