Versions des environnements
>>>Try setting ANSI and EXACT ON before the select, and remove the "==" and see what happens.
>>
>>SET EXACT has no effect on SQL commands and "==" is the same as SET ANSI ON.
>
>I refer you to page 130 of Tamar's Taming SQL and the example of "Smith = S" and the effect of SET EXACT OFF, with SET EXACT OFF the results may not be what you expect.
>
First, thanks for all the kind words about the book.
As for SET EXACT, here's the quote from the book:
[quote]
VFP has an unusual way of comparing strings. When SET EXACT is OFF, strings are compared only to the end of the right-hand string. That means that, in Xbase code, the first comparison here is True, while the second is False:
"Smith" = "S"
"S" = "Smith"
This is convenient for doing look-ups and so forth, though it’s also one of those traps VFP developers fall into regularly.
SQL commands are not affected by SET EXACT. However, the SET ANSI command has a similar impact on them. SET ANSI OFF allows partial string matching in SQL commands.
[/quote]
Note that I say clearly that SET EXACT doesn't affect SQL commands.
That said, I do seem to recall that in at least one version of FoxPro, having SET EXACT and SET ANSI set differently could slow things down. But I don't think that's still true.
Tamar
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement