Paradox Community

Items in pnews.paradox-development

Subject:Referential Integrity
Date:Fri, 30 Nov 2018 13:21:26 -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


Copyright © 2004 thedbcommunity.com