>>just testing... :)
>
>please make it 'set order to ascending' so that they
>surface. i just tested it even without default value of null (i replaced a
>record with .null.) it works.
Just had to test for myself - .null. values come before the blanks in
the index. So we could use (if the need ever arises),
go top
scan while isnull()
...null handling stuff...
ends
scan while isblank()
...blanks handling stuff...
ends
scan rest
...normal stuff...
ends
....since we know it will surely be ordered this way. Well, not in all
collating sequences, since... well, try this:
create table tmp (fld c(6), ii i)
set collate to "slovak"
for i=0 to 255
insert into tmp (fld, ii) value (repl (chr(i), 6), i)
endf
insert into tmp (fld, ii) value (null, -1)
inde on fld tag fld
browse... and get surprised.