Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Errors in RI?
Message
 
 
To
29/09/2001 18:21:19
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00562291
Message ID:
00562295
Views:
16
Cristian,

I don't know, if it would help or not, but in Download section here is a Tax RIBuilder File #9923 by Walter Meester, which is much better and compact, that RI builder in VFP. You may want to try it.

HTH

>Hi,
>
>I try to make a referential integrity on tables like this model:
>
>1. table(A) master with 'iddoc' primary key
>2. 2 tables(B & C) each with 2 fields related to primary 'iddoc' named 'iddoc1' and 'iddoc2'
>3. build RI with RRR rule on all 4 relation
>
>when I try to update a record in (A) wich does not have a related records in (B) OR (C) get error 'Ilegal recursion....' or if I try this from a form 'Variable iddoc2 not found'
>
>What it's happening because 'iddoc2' is there and RI code is generated automaticaly; any solution?
>
>Thanks
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform