Sorting on null text fields

[Ruslan Zasukhin]

On 1/8/05 7:08 PM, "jda" <jda at his.com> wrote:

>>>  authorsSortMethod = CreateTextField("authorsSortMethod", 128,
>>>  EVFlag.fNone, "left(authors, 256)")
>>         ^^^^^^^^
>>         try fNullable
>> 
>> 
>>> 
>>>  Anything I can do about this?
>> 
>> If it is really NULL
>>     (such records must be found by WHERE fld IS NULL)
>> 
>> Then they must go TOP in the sort order.
>> 
> 
> You mean I have to change the method?
> 
> I added EVFlag.fNullable to the current definition, and the records
> still sort randomly.
> 
> I also realize that I wasn't using fNullable in my regular field
> definitions (I am nw) and was nulling them in my code. Valentina
> didn't complain, but perhaps just nothing was being done.

So looks as bug ?

Then we need db + query or project

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