Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger Messages
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00209539
Message ID:
00209548
Views:
23
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
Previous
Reply
Map
View

Click here to load this message in the networking platform