Odd SELECT result - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Odd SELECT result

Message

27/09/2002 11:54:41

Sergey Berezniker
New York, États-Unis

27/09/2002 11:44:43

Caroline Jay
CJG Consultants Ltd
London, Royaume Uni

Information générale

Forum:

Visual FoxPro

Catégorie:

Autre

Titre:

Re: Odd SELECT result

Divers

Thread ID:

00705231

Message ID:

00705283

Vues:

This message has been marked as a message which has helped to the initial question of the thread.

>In the Help it says

>"" = "ab"  is no match

>Is this not my case (comparing an empty string to something)?

It's not true for queries because comparison in queries is controlled by SET ANSI not SET EXACT. So in query

"" = "ab" 
*is the same as 
"ab" = ""

and both return True if SET ANSI is OFF (default). See SET ANSI topic in the help for details.

--sb--

Répondre

Fil

Voir

Click here to load this message in the networking platform