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 TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development