Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with command INDEX
Message
From
02/06/2006 08:10:50
 
 
To
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:
01126709
Views:
28
>>>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

May I ask WHY you have to remove the index file and put a new index on it? Isn't a structural index good enough?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform