Sort IndexbyWords

[Ruslan Zasukhin]

On 3/28/08 12:50 AM, "-= JB =-" <sundown at pacifier.com> wrote:

Hi JB,

> Hi Ruslan,
> 
> Okay I did some reading about IndexbyWords.
> 
> So if the Indexbywords is true you can search it but
> not sort it 

yes

> & if it is false you can sort it but not search it?
 
Not very correct. 

You still can search it, but search will be not by words, but by first 255
chars.


> If the above is true then what can I do to have a field
> that I can search and sort?  Do I need to make two
> separate fields or what?

You need create additional METHOD fldSort in the table, which has formula as
simple as 

     "fld"

And only flag Indexed, but not flag fIndexByWords.

Then you can do

    SELECT fld
    FROM T
    ORDER BY fldSort

 
> I also retrieved the IndexStyles and it only returned
> a number.  Are IndexStyles related?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]