General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error trapping for referential-integrity triggers
Hi all,
In bringing our old FPD 2.5 system into VFP 6, I decided to take advantage of the Referential Integrity features. I understand the concept, but am having some trouble putting it into actual use.
For example, I've got the following two tables:
customer (parent)
orders (child)
One-to-many relationship (obviously) as one customer can have many orders.
I set it up so that if someone tries to delete (for example) customer #200, that will be prevented if there are any orders out there for customer #200 (rules for deleting = restrict).
Now, when I go into my system and try to delete customer #200, I'd like the system to tell the user something like, "Customer #200 cannot be deleted as they have open orders." Instead, I just get a message that says "Trigger failed," and the thing crashes.
I'm assuming there's gotta be somewhere to put code to handle a failed trigger, but where?
Thanks very much!
John
Next
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