>>What other effects does ENGINEBEHAVIOR have? Are other violations ignored? Or do some
>>SQL statements produce different results?
>
>Better to check the help file than ask me. :-)
OK, I will. - It turns out there are several minor differences, including memo fields not supported under certain circumstances, and differences in the evaluation of the LIKE clause. For those that don't have VFP8 installed (like me), the details can be found at
http://msdn.microsoft.com/library/en-us/dv_foxhelp/html/vfp8_lngsetenginebehaviorcommand.asp.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)