ORDER BY

[Halldor Gislason]

Looks like it would be easiest just to skip the kV_IndexByWords on the 
field as you want to sort it - you can still perform all the same 
searches. A second field in the form of a BaseObject method adds an 
overhead that negates the benefits(if any) achieved by using 
kV_IndexByWords

Halldor


On Thursday, January 23, 2003, at 04:19 PM, Rick Robinson wrote:

> Sorry, but I don't understand what you mean by "define second index 
> using BaseObject methods", Ruslan. Are there examples in the 
> documentation that would show me what to do?
>
> Rick
>
>
> On Thursday, January 23, 2003, at 08:55  AM, Ruslan Zasukhin wrote:
>
>> on 1/23/03 5:37 PM, Rick Robinson at rickrobinson at attbi.com wrote:
>>
>> Hi Rick,
>>
>>
>>> Here is the definition:
>>>
>>> name = new VVarChar("name_fld",80,"ASCII",kV_Indexed + 
>>> kV_IndexByWords)
>>
>> Yes, so you have index by words.
>>
>> you can not use sort on it.
>> You need define second index using BaseObject methods
>>
>> -- 
>> 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://listserv.macserve.net/mailman/listinfo/valentina
>> -------------------------------------------------------------
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://listserv.macserve.net/mailman/listinfo/valentina
>>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>