Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with ISBLANK and SELECT SQL
Message
From
18/06/2003 13:48:26
 
 
To
18/06/2003 13:33:49
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00801174
Message ID:
00801321
Views:
18
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
Previous
Reply
Map
View

Click here to load this message in the networking platform