Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with ISBLANK and SELECT SQL
Message
De
18/06/2003 12:55:25
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00801174
Message ID:
00801266
Vues:
19
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform