>>>>>Hi all,
>>>>>can i create a table index with INDEX command by giving the tag and the cdx file name as well.
>>>>>if yes, how?
>>>>>Thanks
>>>>>Tamas
>>>>
>>>>INDEX ON ..... TAG TagName OF CdxFileName
>>>>
>>>>
>>>>Why you need this?
>>>
>>>Hi Boris,
>>>My problem is the following:
>>>I have a table with an index on it. To use that table programatically, I have to remove the index file and put a new index on it.
>>>What I've thought and done so far is that I got rid of the table's index file by flipping the 28.byte of the table flag to 0 and removed the cdx. Then I tried to create a new index with the command INDEX but I wasn't able to.
>>>To be more specific, I managed to create the index but it did not work.
>>>I tried your suggestion too but I got the error message: 'Invalide database....'.
>>>Probably I have to do sg with the dbc file too.
>>>
>>>Tamas
>>
>>You could just use INDEX ON ... TAG (old tag name here)
>>That way you will change index expression and keep old tag name of structiral index.
>
>I assume the problem is that he can't USE the table, because he is missing the function which one of the tags is based on. That's why I suggested that he created a "dummy" function with the correct name, so he won't receive any error when he tries to USE the table.
yes Tore,you're right. I'm working on another solution using command copy to.
Thanks,Tamas