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:
00460046
Vues:
16
>I'm writing an application where I will be updating my database from an XML message. The tables I am updating have insert and append triggers on them. I don't want to fire these triggers if my particular application is the one updating the tables.
>
>I don't have exclusive database access, so I can't exactly change the trigger to suit my needs.
>
>Any thoughts? Is there a simple command I can run that disables the triggers until I issue another command?

That's the thing with triggers, they always fire, no matter how you access the database (VFP IDE, application, ODBC).

Can you modify the trigger to check an application property that your application sets? If it exists, the trigger could immediately return without doing anything.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform