Re: What's your SET ANSI setting? (VFP9SP2)

On 2017-04-08 06:51, Ted Roche wrote:

If you leave them both OFF, you won't run into trouble. Use == for "exactly equals" and you don't need to mess with the setting command.

But set them both ON if that's what you want. With the two settings different, SEEK and SELECT yield different results. Think of ANSI as SET EXACT for SQL statements.

Am I right in saying that my VFP SET ANSI setting had no bearing on my queries to MySQL/MariaDB?