Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Errors in RI?
Message
From
29/09/2001 18:21:19
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Romania
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Errors in RI?
Miscellaneous
Thread ID:
00562291
Message ID:
00562291
Views:
38
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
Next
Reply
Map
View

Click here to load this message in the networking platform