Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL comparison positioning
Message
De
06/01/2000 13:12:24
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
06/01/2000 11:47:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00313954
Message ID:
00314009
Vues:
47
Chas,

Please read about string comparisons in Help under the SET EXACT command.

It says in part:

"String Comparisons

Visual FoxPro has two relational operators that test for equality. The = operator performs a comparison between two values of the same type. This operator is suited for comparing character, numeric, date, and logical data.

However, when you compare character expressions with the = operator, the results might not be exactly what you expect. Character expressions are compared character for character from left to right until one of the expressions isn't equal to the other, or until the end of the expression on the right side of the = operator is reached (SET EXACT OFF), or until the ends of both expressions are reached (SET EXACT ON)."


>
>How would one know he or she has
> to reverse the Field/variable comparisons????????
>
> Thanks, this is a puzzler.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform