Sorting on null text fields

jda jda at his.com
Sat Jan 8 12:08:24 CST 2005


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

Jon


More information about the Valentina-beta mailing list