Sorting on null text fields

jda jda at his.com
Sat Jan 8 11:47:40 CST 2005


  Hi Ruslan,

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

When the authors field is empty (NULL), that record seems to be 
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?

Jon


More information about the Valentina-beta mailing list