Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I intentionally bypass triggers?
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00460037
Message ID:
00464398
Vues:
17
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform