Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger Messages
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00209539
Message ID:
00209548
Vues:
22
Dan,

>Has anyone figured out how to prevent the 'Trigger Failed' messagebox from appearing when a database trigger fails. I'd prefer to handle the failed errors myself.

When are you getting the message? Are you using TABLEUPDATE() to committ the changes to your table?

When TABLEUPDATE() fails (returns .F.) do an AERROR(laError) and then look at laError(1) to determine what caused it to fail. A trigger failure returns a 1539. At this point you can check out the gaErrors array which is created in the RI code to determine which trigger failed. For more info on gaErrors check out the code generated by the RI Builder. It documents what each element in gaError does.

HTH...
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote Technologies
Developer's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform