Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help Please re proper error msg for DBC with RI & Trigge
Message
De
25/04/2001 11:27:42
 
 
À
25/04/2001 09:20:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00499520
Message ID:
00499616
Vues:
18
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
Fil
Voir

Click here to load this message in the networking platform