Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set filter to not empty()
Message
From
02/01/2014 17:12:08
 
 
To
02/01/2014 15:43:49
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
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:
01591273
Views:
54
A binary index, which you can only use on logical expressions, is is much smaller than a normal index, which make it much faster.

>binary index? why? how can a binary index help him?
>
>>and if you index the condition be sure to define as binary...
>>
>>>Thank you Marcia.
>>>
>>>It was a grid problem. Not set filter.
>>>
>>>Moises
>>>
>>>
>>>>Something like: Set filter to not empty(myfield).
>>>>
>>>>But it does not work because this is not the correct syntax.

>>>>
>>>>It works for me.
>>>>
>>>>
>>>>Use MyTable in 0
>>>>Select MyTable
>>>>Set Filter To Not Empty(MyFierld)
>>>>Go Top
>>>>Browse Normal
>>>>
>>>>
>>>>Happy New Year to you too..
Previous
Reply
Map
View

Click here to load this message in the networking platform