Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with ISBLANK and SELECT SQL
Message
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:
00801332
Vues:
16
>
>CREATE CURSOR base (a i)
>APPEND BLANK
>INSERT INTO base values(1)
>INSERT INTO base values(2)
>GO TOP
>
>SELECT a,ISBLANK(Base.a) FROM Base
>
>SELECT a,ISBLANK(a) FROM Base
>
>
>
>ISBLANK() not uses field of SELECT Table.
>
>Final words:
>
>"ISBLANK() is not usable within SELECT"
CREATE CURSOR PirillinoDelPicchio (a c(10))
APPEND BLANK
INSERT INTO PirillinoDelPicchio values("1")
INSERT INTO PirillinoDelPicchio values("2")
GO TOP

SELECT a,ISBLANK(a) FROM PirillinoDelPicchio
Update: Ah, I see you figured this out downthread.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform