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