>Hi,
>Try SET ENGINEBEHAVIOR 70
You must name all the fields, and no fields can be a memo field.
Select field1,field2,field3 from detail group by field1,field2,field3
If you absolutely need to include memo fields, you must use two selects, the first like I explained, the second one to include the memo fields.
When you think about it, the way VFP9 does this, is the only way to get the correct result. The "old way" colud give wrong results, that's why it was changed.