>Is it possible to move a table from DBC1 to DBC2 in a way that won't loose all the special formats and data that are contained in the DBC?
>
>Thanks for any help on this one.
Don,
It's doable in code. However since you need to do it for one time (right?) you can do like this:
-do home()+'tools\gendbc\gendbc' with 'fullpath of DBC1'
-It'd create a prg which is programmatic way of creating the whole DBC1 with its tables/indexes etc.
-Open the generated prg, locate the procedure that creates your table (something like MakeTable_myTable).
-Open your DBC2
-Run the procedure (but first edit filename to include the path where it should be created- ie: it says
create table myTable ...
Make that
create table ('c:\myPath\myTable') ...
append from ('fullpath to your table in DBC1')
-Drop the table from DBC1
PS: If it depends on any stored procedure in DBC1 do not forget to handle it.
Cetin