Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To improve indexing of Dbase
Message
From
27/11/2000 10:18:09
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
27/11/2000 05:42:19
Rahul Murarka
Sys-Con Engineering
Kolkata, India
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00445584
Message ID:
00445673
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform