>>>>>Hi Carole,
>>>>>
>>>>>I don't have MSDN, so I don't have VFP8. In addition, this SET was not in the VFP8 public beta.
>>>>>
>>>>>Can you tell me if this new SET applies only to VFP SQL? By its name, and without other information, it looks like it could apply to all VFP DML commands.
>>>>
>>>>Yes, only native selects. I don't think you really use group by in the other DML commands.
>>>
>>>Using your logic, I wonder why they didn't call it "SET GROUPBYCOMPATIBILITY...". D'ya think it might be because other stuff is affected too?
>>>
>>
>>Well, all the VFP SQL engine changes are grouped into this command. If you read the what's new it lists them. But, (I am pretty sure) they all apply to the SELECT command. Some has to do with grouping, some with using UNION, and a few other issues. (I don't have the release docs with me to double check).
>
>Right, but when it expired I removed all VFP8 from my system. If it had been created as "SET SQLENGINEBEHAVIOR TO..." then I wouldn't have needed to ask any questions about it < s >.
>
Actually there are two commands one is SYS(3099, 70 | 80) and the other is SET ENGINEBEHAVIOR 70 | 80. Both do the same thing. The latter is globally scoped. It doesn't say on the former.
George
Ubi caritas et amor, deus ibi est