Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Carl.
>I am getting frusturated by "Trigger failed" messages that don't tell me what the problem is.
It's actually pretty straightforward -- the trigger failed because (in the case of delete or update) it's found a record in a child table (or in a grandchild or somewhere else down the relationship tree) for the parent record and you've specified a restrict rule. A public array called gaErrors is created, and the 9th element of the first row has the name of the child table that the trigger failed on.
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