Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I intentionally bypass triggers?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00460037
Message ID:
00464398
Views:
18
I used a variation of your method for routing around an SQL Server trigger, by setting a certain bit on the record and checking, in the trigger code, whether or not that bit was set.

I was just trying to avoid doing that in FoxPro, because it's not as neat... T-SQL has the update() function, and I don't know of an analog in VFP.

Anyway, I ended up creating a dummy procedure that's the same name as the trigger. If the data is changed from my form, the trigger calls the dummy procedure (because of how I arranged my SET PROCEDURE calls), but otherwise, it calls the original trigger.

Thanks!
"Once in a while you get shown the light...
in the strangest of places if you look at it right"

Jerry
Previous
Reply
Map
View

Click here to load this message in the networking platform