Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot Modify Table
Message
From
31/01/2008 16:59:56
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01287708
Message ID:
01287719
Views:
11
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform