>>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 #841965
>
>You can also remove the rule temporarily, make your change and put the rule back.

Naomi:

I'm aware that I can use a flag or remove the rule temporarily, BUT that means that I have to remember to execute something before doing a MODI STRU, and I could concievable forget. It would be better if there was somehow a way that the procedure could know that it is in the middle of a MODI STRU operation.