hi all,
i hope i am posting this /beginner) question in the right forum:
i want to create an update trigger, which rolls back a transaction if a record of a table is updated. the table has - amongst others - a field 'statusid' - if a record in this table has the statusid X and it is attempted to update this field to Y, the trigger should rollback the transaction.
thanks for every hint or advise in advance!
k
---------- Post updated at 09:03 AM ---------- Previous update was at 08:23 AM ----------
I was able to help myself 