Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why are these SQL statements different?
Message
De
21/04/2000 12:39:54
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00362213
Message ID:
00362272
Vues:
18
If you read in Help, it says:

"The == operator can be used when an exact comparison of character data is needed. If two character expressions are compared with the == operator, the expressions on both sides of the == operator must contain exactly the same characters, including blanks, to be considered equal. The SET EXACT setting is ignored when character strings are compared using ==."


>Craig, Tamar and Cindy,
>
>? Set('Collate')=Machine
>? Set('exact')=Off
>? Set('ansi')=Off
>? Set('deleted')=On
>
>Should exact be on since I'm using ==?
>
>Thanks for the help,
>Doug
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform