>>Hi all,
>>
>>I ran into a problem today when I needed to add a new file to an existing database container. Under my development environment with a copy of the live database container I added a new file and report. When I tried to add that file from my development environments database container to the live system's container the foxpro environment errored and told me the file is already a part of an existing container being my development environment's container.
>>
>>My question is how do I take a developed table from on container and add it to another without creating the file from scratch ?
>>
>>
>>Thanks,
>>
>>Don
>
>If I understand you correctly, you first need to remove the table from the development database before you can move it to another database. You will lose any long field names, etc because the table becomes a free table. You could make a copy of the table and copy the records from the development table to the other database.
>
>HTH,
I suggest to make a copy from original table and put into backup table which is free table!!!
Select * from TableinDatabase where .T. ;
Into TableisFree
open AnotherDatabase
Add Table TableisFree
....
Then, you don't need to add any more but need to zap the TableisFree and retrieve the data again from TableinDatabase....
Set Safety off
use TableinDatabase in 0 shared
use TableisFree in 0 excl
zap && kill out all record
append from TablinDatebase
set Safety on
....
But you need have a concept that TableinFree is a backup file, don't make any transaction such as add new record, change some field directly!
because it will be overwritten every time!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.