IndexByWords used in sorting????

[Ruslan Zasukhin]

On 6/24/04 9:35 PM, "Juergen Schreck" <lists at innernine.com> wrote:

Hi Juergen, 

> I have a column in my database that has both indexed and indexedByWords
> enabled.
> 
> Whenever I sort on this column with 'Order By' the it doesn't get
> sorted at all:
> 
> Showing etiquette
> Courtesy is so important
> In a gentlemanly manner
> It comes right down to ethical behavior
> Brush up on your manners
> Raising polite kids
> 
> 
> After removing the IndexByWords setting and having only the Indexed
> Flag, sorting works fine. Needless to say, no my Word Match queries
> don't work right. Is the sorting thing a bug? Or is this expected? What
> are my options? Create a method that returns the text unmodified and
> check IndexByWords on that and adjust my word searches to query this
> column instead?

This is expected and described in docs and FAQs.

IndexbyWords cannot be used in sorting, because there is no original STRING,
It was splinted on words.

Solution is:
    you need create on this field BaseObject method that simply is "f1"
    and index it with no IndexByWords.

Then you get actually ONE column, and 2 indexes for it.


-- 
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
-------------------------------------------------------------