Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Make Select quicker
Message
From
26/01/2006 13:16:56
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01090482
Message ID:
01090583
Views:
10
>You can not add NOT EMPTY as a condition, because AFAIK EMPTY is not optimizable. You need to write
>
>not myDateField =={} if you have an index on date.

Naomi, you're right:
ISBLANK() and EMPTY() are not optimizable by Rushmore. (from vfp help)

Ed
Previous
Reply
Map
View

Click here to load this message in the networking platform