Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trapping a RI Delete Error
Message
From
03/04/2000 21:15:22
 
 
To
02/04/2000 18:58:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00354025
Message ID:
00354723
Views:
16
>>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.

I had a similar problem and decided to eliminate the delted mark and provide a command button for an explicit. I also inserted a check in the AfterRowColChange event to enable/disable the delete command button based on my business rule for deleting.

Glen Mettler
Previous
Reply
Map
View

Click here to load this message in the networking platform