Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with command INDEX
Message
De
02/06/2006 08:10:50
 
 
À
02/06/2006 07:43:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01126692
Message ID:
01126709
Vues:
22
>>>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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform