Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IsBlank() in SELECT SQL. Bug?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01346127
Message ID:
01346168
Views:
12
>Hi
>
>Your ISB() function always returns .F. You are passing a value which do contain .F. or 0 and therefore are not blank by definition. If you pass the name of the field and change the last line to RETURN ISBLANK(&pfield), you get the desired results.
>
>Why ISBLANK() in the query isn't working properly is something I've to think about. My first though was that VFP is converting the parameter to a value before passing it to ISBLANK(). Trying to do the same with the similar scenario of empty memo fields, however, showed that VFP is using the field here.

Christof, thanks.

I tried all field types listed in VFP Help for IsBlank(), and it looks like only logical and numeric types do not work.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform