Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Errors in RI?
Message
 
 
To
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:
00562507
Views:
17
Hi,

I used it and haven't found any problems with it. You can direct any questions to Walter, he is frequent here.

>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
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform