Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with ISBLANK and SELECT SQL
Message
From
18/06/2003 13:49:49
 
 
To
18/06/2003 12:04:10
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00801174
Message ID:
00801323
Views:
14
From what Cindy posted in Re: Problem with ISBLANK and SELECT SQL Thread #801174 Message #801310, it looks like the problem I described still exists in VFP7 and VFP8...

>>
>>My tests with VFP6 show that *none* the syntaxes below work correctly. They retrieve the isblank() or empty() value from the current record at the time the query begins. IOW, if you are sitting on the 1st record when you run the query, and it is empty() on that field, it will show that all the records are empty.
>
>I can not test on VFP 6.0.
>
>Agnes
Steve Gibson
Previous
Reply
Map
View

Click here to load this message in the networking platform