Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index on char binary
Message
De
10/09/2004 08:52:46
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00940995
Message ID:
00941003
Vues:
23
>Hi.
>I have index on char binary fields in two tables which i link with relation. The relation works only with the code page under which the index was created. So NOCPCONVERT is neglected when an index is created. This seems illogical... to me at least.
>(VFP 8.0)
>All the best.

hi Kamil,

I think that it is the collating sequence of the index that is important. For binary fields the one to use is 'Machine'. Any other will cause trouble (Kamil = KAMIL = kamil)

So, you may have to drop the indexes and recreate them with Machine collating sequence
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform