Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Shifting Tables in Database
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Groupes d'usagers
Divers
Thread ID:
00048028
Message ID:
00048094
Vues:
14
>>What should I do to shift some tables from one DBC to another DBC without making tables free.
>>Is there any low level trick. And also is there any way to change the directory of tables if tables are belongs to some DBC(without making tables free).
>
>If you mean to make a table a member of two databases, I don't believe that you can. A table's container database is stored in its header info. To change a table from one container tothe other, just remove it from the first and add it to the second. After reading your question though, I became curious as to how the .dbc stores the location of its tables. I opened the .dbc as a table and browsed it: no path information to be found. I guessed that maybe the path would be stored in my dbcx metadata table, so I opened it and looked at the table records: no path. This has got me extremely curious as to how the dbc knows where the tables are. If anyone can enlighten me... please do

You should find a path in the dbc's "Property" field if the table location is different from the dbc. Also, a way to change table directories is just to move them (and any associated files), then open your dbc and try to open the table. The dbc won't find it, but will prompt you to locate it.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform