Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter on .null.
Message
From
30/11/1997 20:11:21
 
 
To
30/11/1997 19:50:50
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00062056
Message ID:
00062982
Views:
36
>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
Map
View

Click here to load this message in the networking platform