Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot Modify Table
Message
De
31/01/2008 16:59:56
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01287708
Message ID:
01287719
Vues:
12
>I have a FoxPro database with many tables. Currently I have the problem that it will not allow me to modify one of the tables because it is in Read Only. Typically this is because someone is utilizing the table through the database. However, I have a table inside the database which keeps track of all users inside the database, and there is no one using the table. Furthermore, I am allowed to rebuild the database despite the fact that this table is Read Only. This only makes the situation more perplexing. Is there some way that the table could remain open (and in turn in Read-Only) even if no one is using the database? Thanks for any information.

Yes there is.
If you have done a simple Select-SQL on the table and did not use NOFILTER VFP will (internally) open the table and use it as the 'filtered result set'. An abomination, but there since forever.

good luck
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform