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:
01346160
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform