Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting/Updating a record in a multitable view
Message
From
30/08/2006 21:31:58
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Deleting/Updating a record in a multitable view
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150033
Message ID:
01150033
Views:
73
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
Next
Reply
Map
View

Click here to load this message in the networking platform