>>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,