General information
Category:
Coding, syntax & commands
>Just had to test for myself - .null. values come before the blanks in
>the index. So we could use (if the need ever arises),
>....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) && line 1
>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.
had to change line 1 to
create table tmp (fld c(6) null, ii i) && line 1
And I could not find a "slovak". Used "iceland" instead.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only