Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using 2 DBCs with the same name
Message
De
27/11/2001 10:43:40
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
À
27/11/2001 10:20:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00586186
Message ID:
00586340
Vues:
24
Mark this is not a problem since the dbc only keeps the logical path to the table e.g. database is on the root folder the tables are on dbf folder under root the databse will keep a referent to dbf\tablename.dbf, being this you can copy the database plus the tables as log as you keep the same structure.

being this the case your problem is resolved.

>I am using UNC paths to connect to my data sources and copying the entire folder just means I have a DBC which is still pointing back to my live files.
>
>
>
>
>>Also Mark if you whant to get everything from live to test then why not copy the all files DBC, DCT, DCX, DBF, CDX, FPT.
>>
>>>Thanks Alexandra
>>>
>>>My problem is that my databases have the same name.
>>>
>>>This is the brick wall I keep walking into:(
>>>
>>>
>>>>Hi Mark you can do the following:
>>>>
>>>>OPEN DATABASE livedatabase
>>>>OPEN DATABASE testdatabase
>>>>use testdatabase!mytable IN 0 ALIAS testtable
>>>>SELECT testtable
>>>>COPY TO mytable DATABASE livedatabase WITH CDX
>>>>CLOSE DATA ALL
>>>>
>>>>>I often have to work with 2 DBCs with the same name.
>>>>>For example my test database and my live database.
>>>>>
>>>>>If I want to zap the tables in my test DBC and append into them from the live DBC I have to use the full path to the live table.
>>>>>
>>>>>Is there someway to set an alias to DBC different from its name?
Alexandre Palma
Senior Application Architect
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform