Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem modifying table structure
Versions des environnements
Network:
Windows 2008 Server
Hello,
I'm having a problem with modifying a table's structure in VFP9 that I've never seen before in 12 years of working with VFP.
I have a database named CCC, and a table in that database called FISCAL. After getting everyone out of that application that uses the database and table AND verifying with the Windows Server tools that nobody has access to the table's files, I issue the following commands in the command window:
OPEN DATABASE CCC EXCL
USE FISCAL EXCL
MODIFY STRUCTURE
All three commands execute successfully, and I see the table name, record count and "Exclusive" use status in the bottom of the VFP screen. However, when the table structure window opens, the Insert, Delete and OK buttons are all greyed out, and I can't modify anything in the table structure. In other words, it's behaving as if I don't have the table opened exclusively.
How can VFP allow me to seemingly open the database and table exclusively, but NOT let me modify anything in the table structure? I've never seen this behavior before, so if anyone has any idea how to rectify it, I'm all ears. By the way, I did try rebooting the server that the database and table reside on, and it didn't make any difference.
Thanks,
Ben
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