Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clean up Database
Message
 
 
To
22/01/1999 10:40:30
Bill Tetrault
Northern Trust Value Investors
West Palm Beach, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00178944
Message ID:
00179409
Views:
22
>I was trying to set up Referential integrety on two table and got a message box that I need to clean up DATABASE Item, it sait go have the database design window open and go to the database menu and choose clean up database. When I try that that option is not availiable, I've made sure I had everything exclusive. VFP 6.0

Issuing a CLEAR ALL before opening DB also helps as well. Close the database before trying to reopen it exclusively. e.g. --

open data MyDbc && opens as shared
open data MyDbc Exclusive && does not close the db first, then reopen as excl.
&& this does work with tables.
close databases
clear all
open data MyDbc excl
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform