Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does a database(DBC/X) open when I USE a table within?
Message
De
26/04/2000 13:27:59
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00363635
Message ID:
00363666
Vues:
19
Ahhh...yes. If you are going to be writing directly to DBC/DBX/DBT files, you can't have any tables open associated with that database.


>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform