Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
To improve indexing of Dbase
Message
De
27/11/2000 10:18:09
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
27/11/2000 05:42:19
Rahul Murarka
Sys-Con Engineering
Kolkata, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00445584
Message ID:
00445673
Vues:
16
>Dear Sirs,
>
>In FP25 if we index on any field it takes into account the symbols and does the indexing.
>
>e.g
>
>1) M.S.Agarwal
>2) M.A.Agarwal
>
>In the above example 2) should come before 1) but it remains as it is.
>
>If dots and space are removed then it works OK.

Then you can have an index expression that'd remove them :

index on chrtran(myField,'. ','') tag myField

But instead I'd suggest doing chrtran() operation in field's valid and have a regular :
index on myField tag myField (or upper(myField)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform