Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Bernard.
>How can I substitute a proper ( one of my own) error message for a database that has triggers and RI?
Since you're using table buffering, the records are only written to disk when you use TABLEUPDATE(). If it returns .F., that means something went wrong, so use AERROR() to see what the problem was. The first element contains the error number, so you can use a CASE statement to control what happens next. Some common error numbers that can occur when saving are 1539 (trigger failed), 1582 (field validation rule violated), 1583 (record validation rule violated), 1585 (update conflict), and 1884 (uniqueness of index violated).
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