General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only