Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with command INDEX
Message
From
02/06/2006 07:43:53
 
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:
01126704
Views:
26
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform