I use it OFF, but then I make exact comparisons using == and using the full length of the field, not just the length of the string.
In example, if the field is C(20) and the string is "word", I first assign PADR(lcString, 20) and then I search it, so I make it independent of SET ANSI. El 8/4/2017 1:20 a. m., <[email protected]> escribió: > Just ran across an instance where I had SET EXACT ON but didn't specify > SET ANSI (for which the default is OFF). After seeing a query for CHICAGO > contain results including others like CHICAGO HEIGHTS, I investigated and > thought my SET EXACT was OFF. Nope, it was ON but my SET ANSI was OFF. > Setting it to ON gave me the results I wanted. > > I'm just surprised this never bit me in all my years doing VFP; I guess > because I've usually been using a RDBMS (like MySQL/MariaDB). > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGQ_Ju=2lc3z4rhfoy1kkzvmp5pfst8yka9eakza+t9batg...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
