Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IsBlank() in SELECT SQL. Bug?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
IsBlank() in SELECT SQL. Bug?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01346127
Message ID:
01346127
Views:
69
Looks like IsBlank() does not work for numeric and logical fields. Am I missing something?
CLEAR
CLOSE TABLES all

create TABLE c:\junk (fldBlob W, fldChar c(10), flddate D, flddt T, ;
	fldg G, fldlogic L NULL,;
	fldM M, fldN N(6,1) NULL,fldfloat F(6,1) NULL, fldVar Q)

APPEND blank

COUNT FOR ISBLANK(fldLogic) OR ISBLANK(fldN) TO ln
?ln   && 1
SELECT * FROM c:\junk WHERE ISBLANK(fldLogic) OR ISBLANK(fldN) INTO CURSOR tmpcurs1
?_tally   && 0
sele;
	fldLogic, ISBLANK(fldLogic) _fldLogic, isb(fldLogic) _fldLogic1,;
	fldN, ISBLANK(fldN) _fldN, ISB(fldN) _fldN1,;
	fldFloat, ISBLANK(fldfloat) _fldFloat, ISB(fldfloat) _fldFloat1;
	from c:\junk;
	into curs tmpcrs2

?ISBLANK(fldLogic), _fldLogic
?ISBLANK(fldN), _fldN
?ISBLANK(fldfloat), _fldFloat


*---------------------------
PROCEDURE isb
LPARAMETERS pField
RETURN ISBLANK(pField)
Next
Reply
Map
View

Click here to load this message in the networking platform