Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set filter to not empty()
Message
From
01/01/2014 11:44:19
 
 
To
01/01/2014 07:58:40
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:
01591212
Views:
77
>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..

Marcia, I am surprised that you can do this mistake. :-)

Set Top can be extremely slooooooow on a big table. Instead you should use Locate.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform