Hi Ed

I have been following this thread and wonder if something like a flag
field would do.

I'm thinking that the Before update trigger looks at a field in the
source table that indicates whether to run the SP or not (essentially a
flag field). We have planned to do this in an up coming project.

That way you could default the field to (Null) to indicate the SP is run
but in the places you don't want it to run you load it with 'stop' value.

Hope that makes sense and is of use :)



Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Ed Dressel wrote:

> Can a stored proc be disable?
>
> What I am needing to do is stop a LastUpdated date-time field from
> being updated when I make a change to a data table.
>
> For example, when I add a field, then set the value of the field, the
> before update trigger will call a stored procedure with a ID of the
> master table to set the LastUpdated field with the current date/time.
> I want to disable the stored procedure from changing so that my
> changes to the table don't set the LastUpdate field for all of the
> records.
>
> Thanks
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>