Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table in database will not open exclusively elsewhere
Message
De
09/01/2002 12:44:25
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Table in database will not open exclusively elsewhere
Divers
Thread ID:
00602588
Message ID:
00602588
Vues:
56
I have a table (mytable) within a database (mydata).

I have these commands:
SELECT * FROM mytable INTO ARRAY aArray
USE IN mytable

After issuing those commands, at a different workstation,
I typed in these commands:
SET EXCLU ON
USE mytable
MODI STRUCT

mytable will not open. Error message:
Database mydata.dbc: File access denied.

I had closed mytable table (USE IN mytable),
but since the table is in mydata database, I cannot open up mytable exclusively elsewhere (without closing mydata database altogether)?

What I'd like to have is to retrieve data from myTable, and when that's done, to be able to open up myTable exclusively elsewhere (so that I can MODIFY STRUCTURE whenever I need to), without closing the whole mydata database.

Can anybody shed light?
Thank you all!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform