Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with ISBLANK and SELECT SQL
Message
From
18/06/2003 12:55:25
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00801174
Message ID:
00801266
Views:
18
Hi Jim,

i have found the problem:

- ISBLANK() not support INTEGER fields;
- ISBLANK() not support NUMERIC fields on SELECT.
- ISBLANK() not support LOGICAL fields on SELECT.
- ISBLANK() support DATE,DATETIME,CHARACTER,MEMO,GENERAL fields on SELECT.

- ISBLANK() not support TABLE name on SELECT
-
CREATE CURSOR PirillinoDelPicchio;
(a N(10,0),b L DEFAULT ISBLANK(a);
,c N(10,0) DEFAULT a, d L DEFAULT ISBLANK(c);
,e C(10),f L DEFAULT ISBLANK(e);
,h D,k L DEFAULT ISBLANK(h);
,r L,s M,y Y,t T)

APPEND BLANK
INSERT INTO PirillinoDelPicchio (a,e) values(1,'')

INSERT INTO PirillinoDelPicchio (a,e) values(2,' ')
INSERT INTO PirillinoDelPicchio (a,h) values(0,DATE())
GO TOP
? a,ISBLANK(a),ISBLANK(r)
BROWSE

SELECT a,ISBLANK(a),e,ISBLANK(e),h,ISBLANK(h),r,ISBLANK(r),s,ISBLANK(s),t,ISBLANK(t),ISBLANK(y) FROM PirillinoDelPicchio
Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform