Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ORDER BY versus INDEX ON...issues?
Message
 
 
To
11/08/2004 12:48:46
Scott Malinowski
Arizona Fox Software LLC
Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00932358
Message ID:
00932408
Views:
21
Yep. My second and third fields were empty intead of null. When I made them null, I get the same results as you. This works:

INDEX ON f1+NVL(f2,'')+NVL(f3,'') TAG f1

>Could this have anything to do with the fact that two of the index fields could be NULL? That is, the join for two of the tables is a LEFT OUTER JOIN which means the records without a matching join will contain NULLs. That's the one thing I do notice when I test the supposed blank fields, they have NULLs in them.
>
>Which makes them sort ike:
>
>AAA NULL NULL
>CCC NULL NULL
>AAA AAA AAA
>BBB AAA BBB
>CCC CCC CCC
>
>Hmmmmmmmmmmmmmm???????????????????????????????
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform