Information générale
Catégorie:
Codage, syntaxe et commandes
>>>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-
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement