Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the best index expression?
Message
 
 
To
18/04/2005 13:43:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01005870
Message ID:
01005889
Views:
22
>
INDEX ON EMPTY (MyField) TAG E_MyField
>SET FILTER TO NOT EMPTY (MyField)
HTH
>

I have some doubts about this solution... But anyway, I'll try it out.

>>If I want to filter all non-empty values for character (100) field, what would be the best expression for the index (if I need the index)?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform