Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error Messages...
Message
From
04/04/2000 04:10:09
 
 
To
03/04/2000 17:18:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00354617
Message ID:
00354860
Views:
21
Hi Favio.

>> How can I personalize the error messages, when it fails some component of the referential integrity in the update of a database ? <<

You need to use AERRORS() to check for why the tableupdate failed and personalize your message there:
IF !TABLEUPDATE( 0, .F., 'SomeAlias' )
   AERROR( laErrors )
   *** Check for trigger failed
   IF laErrors[1] = 1539
      DO CASE
         *** Insert Trigger
         CASE laErrors[5] = 1
         
         *** Update Trigger
         CASE laErrors[5] = 2
         
         *** Delete Trigger
         CASE laErrors[5] = 3
      ENDCASE
   ENDIF
ENDIF
HTH

Marcia
Previous
Reply
Map
View

Click here to load this message in the networking platform