Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table being opened as READONLY some of the time
Message
De
02/03/2015 10:50:00
Rob Clapworthy
Bespoke Software Systems
Royaume Uni
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Table being opened as READONLY some of the time
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP3
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01616088
Message ID:
01616088
Vues:
63
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform