Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Errors in RI?
Message
De
29/09/2001 18:21:19
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Roumanie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Errors in RI?
Divers
Thread ID:
00562291
Message ID:
00562291
Vues:
40
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform