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?

Nobody???

How do you know the file has GFE's?

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

Is there also another way?

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.

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.

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.

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

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

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.

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

Thanks Sean,

Re-building the template fixed it.

View this thread on the Works forum...