Copy_Table (OpenInsight Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Copy_Table (OpenInsight Specific) ====
=== At 07 JUL 2000 12:33:43PM Fred Johnson wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
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


</QUOTE>
----

=== At 07 JUL 2000 04:12PM Oystein Reigem wrote:  ===

<QUOTE>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 -

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=8A252B1B430703D985256915005AFA99|View this thread on the  forum...]]