Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trapping a RI Delete Error
Message
From
02/04/2000 18:58:11
 
 
To
02/04/2000 09:09:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00354025
Message ID:
00354100
Views:
25
>If I have defined relations between two tables in the DBC and generated RI code for deleting. How do I trap an error when I try to delete a record that can't be deleted? In otherwords if I have an updateable grid and the user clicks on the delete box in the grid. In my save button I do a TABLEUPDATE. Is there a way to trap that error from the RI code?
>
>Thanks

Been a while since I looked at the generated RI code, but I believe it creates a public array with error info in it. You should be able to trap the error in your form's error event, and check the contents of gaErrors[] (or whatever it is called) to give the user a meaningful message.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform