{{tag>category:"OpenInsight 32-Bit" author:"Kauko Laurinolli" author:"John Bouley" author:"Mark Marsh" author:"Aaron Kaplan" author:"Sean FitzSimons"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Copy_Table & GFE (OpenInsight 32-Bit) ====
=== At 10 JAN 2009 09:38:22AM Kauko Laurinolli wrote: ===
 
 
<QUOTE>
Using v8.07 and UD3.0.0.3.

When doing:

!----------------------------------------------------------------

Status="

Copy_Table("LOG_TEMPLATE", DATA_DIR, "MYAPP", 'LOG_2009-01', "0", "0", "0", "0", Status, "0")

If Get_Status(status_code) Then msg(status_code:' copy failed')

Attach_Table(DATA_DIR, TableName, "MYAPP", "")	

If Get_Status(status_code) Then msg(status_code:' attach failed')

!----------------------------------------------------------------

the new table always has GPE even the empty source table "LOG_TEMPLATE" doesn't have any GPE's?

Is this UD3.0.0.3 error or what?
</QUOTE>
----

=== At 14 JAN 2009 07:15AM Kauko Laurinolli wrote:  ===

<QUOTE>Nobody???

</QUOTE>

----

=== At 14 JAN 2009 07:49AM John Bouley wrote:  ===

<QUOTE>How do you know the file has GFE's? 

</QUOTE>

----

=== At 14 JAN 2009 09:47AM Kauko Laurinolli wrote:  ===

<QUOTE>Database Mgr/Utilities/OI Tables/LH Verify says there is GFE error in every table created w/ copy_table.

Is there also another way?

</QUOTE>

----

=== At 15 JAN 2009 11:49AM Mark Marsh wrote:  ===

<QUOTE>You could create an empty table and Dictionary and then row_copy the dictionary records over and the data records over.



Alternative 2:

Create an empty table,  use List_volume to find out what the revxxxx.lk and .ov files are and then copy the source tables revxxx.lk and .ov files over the top of the empty table.



but copy_table should work,  are you running the copy_table command in the system monitor ? and do you get an error ?

Are there relational indexes on the table ? I believe there has been an for along time with them and copy_table.

</QUOTE>

----

=== At 15 JAN 2009 02:48PM Kauko Laurinolli wrote:  ===

<QUOTE>This is done in Basic+ program so manual manipulation is not possible.

No indexes in the table. The template is just a simple and empty monthly access log.



</QUOTE>

----

=== At 18 JAN 2009 09:12AM Aaron Kaplan wrote:  ===

<QUOTE>What's the status error being returned.

You have called SET_STATUS(0) before running, right?

What's the actual code, because I think you've posted a pseudo-code rendition.

</QUOTE>

----

=== At 19 JAN 2009 07:46AM Kauko Laurinolli wrote:  ===

<QUOTE>Status returns: Status=1.

Code:

Today=Oconv(Date(),"DJ4-")

TableName=LOG_': Today1,4: '_':Today6,2

DATA_DIR=Trim(XLATE("CONFIGURATION",1,10,"X"))

Attach_Table(DATA_DIR, TableName, "NOSS", "")  ;**  attach if exist

Ret=TableExists(TableName)	 	       ;** exist or not

If Ret=0 Then

  Set_Status(0)	

  Status="

	

  Copy_Table("LOG_TEMPLATE", DATA_DIR, "NOSS", TableName, "0", "0", "0", "0", Status, "0")

  If Get_Status(status_code) Then msg(status_code:' LOG_TEMPLATE copy failed')

  Attach_Table(DATA_DIR, TableName, "NOSS", "")

  If Get_Status(status_code) Then msg(status_code:' new table attach failed')

End

</QUOTE>

----

=== At 19 JAN 2009 08:50AM Aaron Kaplan wrote:  ===

<QUOTE>Where are you getting the status that indicates a GFE and what is the actual error text?



</QUOTE>

----

=== At 19 JAN 2009 10:11AM Kauko Laurinolli wrote:  ===

<QUOTE>I am not getting any error message but when I go to:

Database Mgr/Utilities/OI Tables/LH Verify says there is GFE error in every table created w/ copy_table.

</QUOTE>

----

=== At 19 JAN 2009 10:46AM Sean FitzSimons wrote:  ===

<QUOTE>Kauko,



If you delete your existing LOG_TEMPLATE and create it again from scratch and then run your Copy_Table routine do you receive GFEs?



Sean

</QUOTE>

----

=== At 19 JAN 2009 11:06AM Kauko Laurinolli wrote:  ===

<QUOTE>Thanks Sean,

Re-building the template fixed it.

</QUOTE>


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