Beware the comment at the end of the article, which points out this is an Xbase rule, and that SQL statements (not just SELECT - SQL, but INSERT, UPDATE, DELETE, etc.) follow SET ANSI instead of EXACT. A good guideline is that both ANSI and EXACT should be set to the same value, to avoid problems with mixing xBase and SQL clauses.
On Sat, Dec 12, 2015 at 6:45 AM, Thierry Nivelet <[email protected]> wrote: > Google took me inadvertently to this page with a comprehensive explanation > about =, == and set exact > > https://msdn.microsoft.com/en-US/library/9z694sba(v=vs.80).aspx > > Thierry Nivelet > http://foxincloud.com/ > Give your VFP app a second life in the cloud [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/cacw6n4u6rc_hkv3t+iu05oi1mn34ry5rudfwpg2xtleuo0d...@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.
