Subject: | Referential Integrity
| Date: | Fri, 30 Nov 2018 13:22:57 -0800
| From: | Peter <peter@whiteknight.email>
| Newsgroups: | pnews.paradox-development
|
I learned sometime back that the problem with using ri is that when a
child table is locked, Pdox places a lock on all the parent tables upstream.
The advantage of it is that when the parent table is updated then the
child table's foreign keys are also updated at teh same time. This has a
huge benefit in the following dm
Owner -->> Vehicle -->> Invoice Hist
Oid Vid Iid
Oid (fk) Vid (fk)
Oid (fk)
In the above example if a vehicle is sold to another customer then the
O(wner)id is changed in the Vehicle table but if connected using ri then
it (Oid) is also updated automatically in the invoice history table.
I have hundreds of tables that have foreign keys of the above tables. If
I do not use ri then the only thing I can see is maintaining a list of
all child tables and run a syncronizing routine on each in the correct
sequence.
Is there any other way of approaching this besides using ri?
Thanks for any thoughts.
Peter
|