General information
Category:
Coding, syntax & commands
>>>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.
You need to pass the information from the trigger code back out to the app. You can do this using a global variable or app object. If you use an app object, make sure you check it exists in case the trigger fires outside your app.
-Doug-
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only