Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Referential Integrity - Database Cleanup
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01104929
Message ID:
01105337
Vues:
20
>>Just to add to this, this doesn't always give you excl access, I've found (with VFP 3 and 7). Sometimes you have to:
>>- close the project,
>>- then close VFP,
>>- open VFP (without the project auto opening),
>>- then: OPEN DATABASE MYDBC EXCL
>>
>>Go figure
>
>Actually, what I've found is that CLOSE DATABLASE ALL from the command line doesn't always close the database if you have the database open from the project manager (PM). So when you issue OPEN DATABASE EXCLUSIVE, the DB is not opened exclusively. Naturally, one is not able to see the options such as "clean up database" from the database menu when the DB designer is open.

That's probably what I've been experiencing but maybe I'd always assumed that the "close data" was successful. So whereas "Open data excl" didn't seem to work it was really ignoring the command cos it was already open? So going about it as I outlined is tackling the same problem that you described :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform