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