>>I would like to know during data entry into a table which trigger have failled. My objective is to intercept the message "trigger failled" to inform the user a message more specific.
>
>In your trigger code, make sure you have ON ERROR assigned to do something to prevent the "trigger failed" message. If your TABLEUPDATE fails, use AERROR() to get error. Handle the error as appropriate.
>
>-Doug-
Ok. I have the ON ERROR routine. I would like to discover, which table parent
had failled?
For example:
When I am inserting record on a table that is child of many others parent table.
The trigger failled and I would like to discover which table doesn't have parent
record.
Antonio Carlos Kleinübing
Systems Analyst