Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help Please re proper error msg for DBC with RI & Trigge
Message
From
25/04/2001 11:27:42
 
 
To
25/04/2001 09:20:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00499520
Message ID:
00499616
Views:
17
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
Previous
Reply
Map
View

Click here to load this message in the networking platform