Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table being opened as READONLY some of the time
Message
From
02/03/2015 10:50:00
Rob Clapworthy
Bespoke Software Systems
United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Table being opened as READONLY some of the time
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP3
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01616088
Message ID:
01616088
Views:
64
Hi

My application is in use by 10 machines all over the UK.

Each installation is stand alone.

One of my users is having problems where a table seems to be being opened as READONLY?

This seems to be intermittent, this problem is not occurring to my knowledge on any of the other 9 installations.

I open my tables using the dataenviroment of each form.

It is always the same file that this is happening on.

The error I get when trying to update this file is obviously "Cannot update the cursor SCHEDULEBODY, since it is read-only."

I have used GOFISH4 and can find no other ways this file can be being opened READONLY? dataenviroment for this table is set to Readonly .f.

1) Anybody got any suggestions on how this could be happening

2) Using the ISREADONLY command I am quite willing to write a routine that
checks a passed tablename is open as READWRITE and if not will open it in the same select area as READWRITE with same indexes/order set.

3) Or should I be capturing the error and trying to reopen the table as READWRITE as part of a n error trap routine?

Any help much appreciated
Next
Reply
Map
View

Click here to load this message in the networking platform