>Hi all:
>
>I have a record validation rule that fires a stored procedure that updates a 'lastupdated' field.
>
>However, I want this to execute only when the user makes a change.
>
>I've found that whenever I do a MODIFY STRUCTURE, the procedure fires for every record in the table!
>
>How can I stop this?
>
>Thanks,
>
>Yossi
If you're using ALTER TABLE command, look at NOVALIDATE clause. Otherwise include some flag into your validation procedure to not fire and set this flag to true before running MODIFY STRUCTURE command.
See, for example,
Re: Is it possible to prevent field validation from running? Thread #
841695 Message #
841965You can also remove the rule temporarily, make your change and put the rule back.
If it's not broken, fix it until it is.
My Blog