Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BIG BUG: Index not support binary strings
Message
From
14/11/2003 09:59:36
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
14/11/2003 04:53:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00849781
Message ID:
00849874
Views:
16
This really smells like a nasty bug.

And the weirder thing is that, contrary to my previous experience, it now (vfp7.1) behaves OK with collating sequence "General", "German", "Iceland", "Nordan"... but returns .f. after reindex on "machine".

>I replay the problem in simpler way.
>
>
>CLEAR
>Create Cursor test(F1 C(2))
>
>Index On F1  tag Num
>
>Insert into test(F1) values ('A ')
>Insert into test(F1) values ('A'+CHR(0))
>Insert into test(F1) values ('B'+CHR(0))
>
>? 'Found() = ', KEYMATCH('A'+CHR(0)),SEEK('A'+CHR(0)),INDEXSEEK('A'+CHR(0))
>
>REINDEX
>
>? 'Found() = ', KEYMATCH('A'+CHR(0)),SEEK('A'+CHR(0)),INDEXSEEK('A'+CHR(0))
>
>LOCATE FOR F1=='A'+CHR(0)
>? FOUND()
>SELECT * from ALIAS() WHERE F1=='A'+CHR(0)
>
>
>Then, when a string Index expression can end with CHR(0), VFP index is bad.
>
>On Message #849429 i put a workaround.
>
>Fabio

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