Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Errors in RI?
Message
From
01/10/2001 04:48:28
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:
00562417
Views:
15
Hi,

The proposed file is still in beta but it has some interesting features; do you know of everyone it using it - some feedback from them ?

Meenwile I found problem that generates this issue: in riopen procedure open of tables needed is done in two ways: 1 if table is not open it is open and selected area of new table opened, 2 if table is allready opened it do something internal but don't select it's area remaining selected area of table (A) wich does not have field iddoc2 or iddoc1 and generates error

Thanks

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform