Hi Rick,
I guess the first question of most importance is:
Can we use Before Update or Before Insert triggers to intercept and
modify column values (timestamps or otherwise)?
The over simplified example was to show that the before triggers were not
functioning as expected so attempts as
Is there some reason that you have to solve this problem with triggers?
An alternative solution would be to perform your integrity checks in a
database procedure which runs with DEFINERS rights and to restrict
UPDATE privilege on the table to the table owner.
On 12/1/23 10:15 AM, Steven