Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table access (can't avoid read-only)

Status
Not open for further replies.

CCorax

Programmer
Feb 6, 2002
10
US
I have a fairly small application set up in FoxPro 6. In the project manager I have added a database with a few tables for use by the application.

On running the application. I "Set Exclusive On" and "Open Database". Then throughout the app, I "USE" the tables as I need them. The problem is, whenever I try to modify the tables, I get an error because they are read-only! This only happens when I open them in the code.

So if I set a breakpoint in my code right before this...
USE MY_TABLE

Then copy that line into the command window and run it, it opens the table read/write. Then I close the table and F6 through the above line. *It opens it read-only!!!*

Arg! Please help.

Thanks,
C
 
If sounds like you included the tables in the projects by mistake. If you do that they are built into the app and are reald only. Got to the project manager right click on the tables and the database and select exclude. This will keep the reference to the database and tables in the project but prevent them from actuall being built into the app itself.
 
No dice. I excluded the db and still have the problem.

C
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top