Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BIG BUG: Index not support binary strings
Message
De
14/11/2003 09:59:36
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
14/11/2003 04:53:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00849781
Message ID:
00849874
Vues:
17
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform