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 23:48:46
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
30/08/2006 21:31:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150033
Message ID:
01150052
Views:
27
>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.

I'd try the simple stuff first:

close data all
set exclusive on
open database {your dbc here}
modify database

Then come back here if it still won't.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform