Copy_Table in runtime apps (OpenInsight 32-Bit) [Revelation On-Line Wiki]

OpenInsight 32-Bit, Alun Hutchings, Kauko Laurinolli

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

At 06 AUG 2009 04:35:38AM Alun Hutchings wrote:

I want to back up my data tables in a runtime environment. One of those tables has a relational index applied and although the following argument works in a development system, it does not in the runtime. Has anyone found a work around?

Copy_Table(Table, TargetDir, Database, NewTableName, 0, 0, 0, 0, flag, 1)

At 06 AUG 2009 08:38AM Kauko Laurinolli wrote:

I use the following in runtime 8.0.8 and it works just fine.

TableName=LOG_': Oconv(Date(),"DJ4-")1,4: '_': Oconv(Date(),"DJ4-")6,2

Attach_Table("MY_DAT", TableName, "MY_APPLICATION", "")

Ret=TableExists(TableName)

If Ret=0 Then

* If not exist Copy template to monthly table
Set_Status(0)
Copy_Table("LOG_TEMPLATE", "MY_DAT", "MY_APPLICATION", TableName, "0", "0", "0", "0", Status, "0")
If Get_Status(status_code) Then msg(status_code:' LOG_TEMPLATE copy failed')
Attach_Table("MY_DAT", TableName, "MY_APPLICATION", "")
If Get_Status(status_code) Then msg(status_code:' new table attach failed')
End

At 06 AUG 2009 09:18AM Alun Hutchings wrote:

The problem exists only where relational indexes are applied. Other tables will copy fine.

View this thread on the Works forum...