Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with ISBLANK and SELECT SQL
Message
From
18/06/2003 13:21:09
 
 
To
18/06/2003 13:17:29
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:
00801288
Views:
11
Hi Cindy,

Mystery 1, Us 0.

Here is the code from my prg. As far as I can tell, it's the same as yours.
CREATE CURSOR aTable (cField C(1))
INSERT INTO aTable VALUES ("1")
INSERT INTO aTable VALUES ("")
INSERT INTO aTable VALUES ("3")

SELECT ISBLANK(cur1.cfield) FROM atable as cur1
Alan

>>Cindy, your code doesn't work for me in either VFP7 or VFP8 on WinXP. I get the error 'Object Cur1 not found'
>
>I'm using VFP8 on WinXP. The code was copied directly from my Command window. Are you sure you don't have a typo somewhere? (Try copy/pasting my code in to a code window and running it.)
>
>If that doesn't work then we have a mystery!
Previous
Reply
Map
View

Click here to load this message in the networking platform