Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set filter to not empty()
Message
 
 
To
02/01/2014 11:33:15
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01591204
Message ID:
01591256
Views:
70
Most likely it'll error out because filter expression is evaluated at the time when record pointer moves. lcSpaces may be out of scope than.

>EMPTY() is not Rushmore optimizable unless you add an INDEX ON EMPTY(myfield). That is a non-discriminating index. If you already have another index on myfield like this... INDEX ON UPPER(myfield) TAG xmyfield
>
>then the following will work.
>
>lcSpaces=space(len(myfield))
>SET FILTER TO UPPER(myfield) # m.lcSpaces
>
>You won't need a new index and it will optimize.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform