Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with ISBLANK and SELECT SQL
Message
De
18/06/2003 13:48:26
 
 
À
18/06/2003 13:33:49
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
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:
00801321
Vues:
19
Cindy,

I'm still on VFP6. What do you get when you add GOTO 2 into the code? I'm betting you'll get TRUE for all records...ISBLANK() is not firing for each record when you put the table name into the function call. EMPTY() behaves the same way.
CREATE CURSOR aTable (cField C(1))
INSERT INTO aTable VALUES ("1")
INSERT INTO aTable VALUES ("")
INSERT INTO aTable VALUES ("3")
GOTO 2
SELECT ISBLANK(aTable.cField) FROM aTable
SELECT ISBLANK(Cur1.cField) FROM aTable Cur1
>FPW2.6 - ISBLANK() returned True for the second record for both Cur1 and aTable. No errors.
>VFP6 - Returned all three rows as False for the aTable selection and errored on the Cur1 selection.
>VFP7 - Same as VFP6.
>VFP8 - All three records return False, no errors.
Steve Gibson
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform