Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT with Memo = Bug?
Message
 
 
To
31/08/2001 03:42:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00551257
Message ID:
00551328
Views:
20
>Hello
>
>Yes the problem is because always in VFP : ('' = 'a') or ('' = 'x') ...

Not always but never. ('' = 'a') and ('' = 'x') always return .F.

>
>You must add : AND !EMPTY(xx)
>
>Goodbye
>
>Lionel

On other hand. the result of ('a' = '') or ('x' = '') depends on setting of SET ANSI for the SQL select and SET EXACT for the rest of commands.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform