Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting/Updating a record in a multitable view
Message
De
30/08/2006 21:31:58
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Deleting/Updating a record in a multitable view
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01150033
Message ID:
01150033
Vues:
74
Hi all,

Strange, but true, I have gotten used to using stand-alone tables in the dataenvironment of my forms, instead of using views, because, at inception and design, I possibly found the learning curve too steep, and the benefits not inspiring enough at the time.

Today, as I redesign my application using database features and views, here is one of the problems I encounter:

I intend to delete a record in a multi-table view, which means, both the parent and the child record should go with a single delete command in a form. I have been working with the database, and trying to simulate the relationship in the view, click on the link, and develop a Referential Integrity. However, I get this error message:

"This DBC is not open for exclusive use.You will not be allowed to generate RI through this DBC."

Any help will be greatly appreciated.

Thanks!

Steve
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform