Sorting on null text fields

[Ruslan Zasukhin]

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

Hi Jon,
 
> I'm seeing some odd behavior, and I want to understand if I can fix it.
> 
> I have records sorted by this method:
> 
> authorsSortMethod = CreateTextField("authorsSortMethod", 128,
> EVFlag.fNone, "left(authors, 256)")
        ^^^^^^^^
        try fNullable

> When the authors field is empty (NULL), that record seems to be

Empty is not the same to NULL.

> randomly returned. It's sometimes at the beginning, sometimes at the
> end, and sometimes in the middle of the cursor.
> 
> 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.


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