Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP8SP1: New (?) BUG using indexes with BINTOC...
Message
De
12/11/2003 20:51:18
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
12/11/2003 11:32:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00849039
Message ID:
00849381
Vues:
24
>Hi Emanuele ( ciao ),
>
>The problem is a global problem.
>
>If you use REINDEX, Moving index definition it does not prevent the situation:
>

>**-------------------------------------------------
>Create Cursor test(CodeTest char(5), Num I NULL)
>
>Index On (CodeTest + BinToC(Num)) tag Num

Make sure the collation sequence on that index is "MACHINE". Any other sequence will give you seemingly illogical results. If you have "General" or any other as the collate sequence when you build an index on anything but pure text strings, expect problems.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform