Copy_Table and Indexing (OpenInsight 32-Bit)
At 17 JUN 2008 10:52:09AM Mat Kelly wrote:
I have a simple copy table command that appears to be failing because of an unexplained indexing file. My code is:
STATUS_CODE="
Set_Status(0)
Copy_Table("MY_TABLE","PATH\TO\TABLE",'MY_APP',"MY_TABLE_BKP",0,0,1,0,STATUS_CODE,1)
If Get_Status(STATUS_CODE) Then
Call Msg("Error: ":STATUS_CODE,"","","")
Return
END
The program always hits the FS146 error citing that !MY_TABLE_BKP already exists. I have checked the list of indexed tables in the Database Manager and !MY_TABLE_BKP is not listed. Is it possible that the table was deleted without deleting the index? If so, how do I remove only the index? If not, what else could be going wrong?
Thanks.
At 17 JUN 2008 11:10AM Mike Ruane wrote:
Mat-
If you do a list_volume on the diretory in question, does the file already exist there?
It may exist and not be attached.
Mike
At 17 JUN 2008 11:27AM Mat Kelly wrote:
That seemed to be the problem. Thanks, Mike!