Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP8SP1: New (?) BUG using indexes with BINTOC...
Message
From
12/11/2003 20:51:18
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
12/11/2003 11:32:14
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00849039
Message ID:
00849381
Views:
23
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform