Case and sorting/searching

[Ruslan Zasukhin]

On 9/16/04 2:23 AM, "jda" <jda at his.com> wrote:

I did not check this yet.

 
> Ruslan,
> 
> 
> In my 1.x app I use methods to allow lowercase searches and sorts.
> 
> The basic field is declared like this:
> 
>    authors = CreateTextField("authors", 128, "English")
> 
> For searches I need indexed by word, so use this method:
> 
>    authorsMethod = CreateTextField("authorsMethod", 128, "English",
> Valentina.fIndexByWords, "Upper(authors)")
> 
> 
> And for sorts I need to sort by first characters, so use
> 
>     authorsSortMethod = CreateTextField("authorsSortMethod", 128,
> "English", Valentina.fIndexed, "Upper(authors)")

Btw interesting!

How many first characters you want to sort?

E.g. If only 20, then you can and should extract only them.
This will be more effective.


> Can I get rid of these methods (or at least one of them) in 2.x? If
> so, how should I create the authors field?

AuthorsMethod yes.

Wait. I need check this self yet

Simply you will tell to authors field that it must have
Case insensitive index.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------