General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Joe,
After you USE it to close it again, issue CLOSE DATABASE
HTH,
Phil
Joe wrote:
Wrong choice of words...I am replacing my database files (DBC/DBX) and wondering if because I opened a table that is associated with that DBC is the DBC still somehow open or in use even after I USE my original table to close it again.
>Data dictionary? Is this a table?
>
>
>>I talking about the file being physically open as per the operating system.
>>I've run acrossd a problem where I can't overwrite my datadictionary (when I want to) because it appears that it's in use. All I have done is USEd a table from it and then close that same table with another USE. Is the datadictionary left mysteriously open or in use? I can't see it in DISP STATUS, but still I wonder...
>>
>>>It is and it isn't :-)
>>>
>>>The database is respected insofar as triggers, field level rules, etc when the table is opened. But you need to SET DATABASE TO or OPEN DATABASE explicitly to be able to query database properties with DBGETPROP() or to return the proper value for DBC().
>>>
>>>
>>>>If I USE a table that is in a database, and then do a DISPLAY STATUS, the database does NOT show as being open. However, I suspect that I might be.
>>>>
>>>>Am I WAY off, or is there something to this...
>>>>
>>>>Thanx,
>>>>Joe Pirola
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only
