I'm trying to use Copy_Table in a program to copy an existing table to a new table using the following code:

Copy_Table('DATATABLE',,,NewName,,,,)

DATATABLE is the name of the existing table.

NewName is the name of the new table that I want to create.

The new table to be in the same location and database as DATATABLE.

The result I have been getting is DICT.TEMP…

Can someone show me what I'm doing wrong?

Thanks

Fred

Fred,

Had that problem too once. And I who usually write down everything so I won't forget, didn't do it this time….

But your Copy_Table looks right. However, you need to attach the table afterwards, with the Attach_Table subroutine. Since Attach_Table only attaches the table temporarily you might want to use the Define_Database subroutine too, to make the new table a permanent part of your database.

The thing I don't quite remember is how it is with this DICT.TEMP table. (That's it's full name, isn't it?) Perhaps it's a result of one doing the Copy_Table several times. (I assume you have tried several times with the same destination table.) The second time it already exists, but it's not in the database, so something goes wrong. I think.

- Oystein -

View this thread on the forum...