>>Hi all,
>>how is it that it is that you find out what trigger is failing.... and what can you do about it. it might be a lame question, but i just don't have a clue.
>>when i open a table and mark it for deletion and go to close it, it gives me a trigger failure.
>>
>>please help.
>>Jordan
>
>Fire off AERROR() after the trigger failure, then check array element # 5.
>
>1 – Insert trigger failed.
>2 – Update trigger failed.
>3 – Delete trigger failed.
If you are the author of the trigger, you can consider having the trigger give feedback on the reason for failure. I use a public variable to store a message string explaning the reason for failure. (I know public variables have dangers, I just haven't come up with a better solution, yet) This also slows down updates to my database from outside my application. They have to declare the public variables or the triggers always fail!
HTH,
Bill Armbrecht
VFP MCP