Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Table in database will not open exclusively elsewhere
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement