Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with command INDEX
Message
From
02/06/2006 11:22:21
 
 
To
02/06/2006 09:16:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01126692
Message ID:
01126773
Views:
21
>>>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform