Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jalamang Jobarteh
  Where is Jalamang Jobarteh?
 Serrekunda
 Gambia
 Jalamang Jobarteh
 Tags
Subject: Trigger Fail Message
Thread ID: 143200 Message ID: 143200 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: General VFP Topics
Date: Saturday, August 25, 2007 9:47:05 PM         
   


Hello guys

We are trying to implement referential integrity between two tables. When we try to delete a record from the parent table for which there are children records the system gives an error message 'trigger fail' which we can understand.

What we would love to do is to intercept that message so that instead of the system giving the error message on the screen we give our own so that the delete record program will finish gracefully.

We would be grateful if you could give us the code that we can use with the delete command to achieve that.

Thank you very much for your assistance.

Best regards
Jalamang

ENTIRE THREAD

Trigger Fail Message Posted by Jalamang Jobarteh @ 8/25/2007 9:47:05 PM
RE: Trigger Fail Message Posted by Koen Piller @ 8/26/2007 8:00:14 AM
RE: Trigger Fail Message Posted by Jalamang Jobarteh @ 8/27/2007 1:37:49 PM