>>>Thank you, Chuck and Sergey.
>>>
>>>i really couldn't understand why Microsoft changed the "group by" syntax and I don't understand how I can do to fix my instruction but your explanation was good for me.
>>>
>>>Thank you again.
>>>
>>> Héctor
>>
>>MS changed the syntax to make it more ANSI standard. Other languages don't allow to use non-aggregate fields in Select-SQL without GROUP BY.
>
>Yes. And if you think about it, the old VFP way is conceptually impure. If a column is not an aggregate function or one of the GROUP BY terms, you are going to get the value from an arbitrary row.
Not in any case. For example if you have a 1 to n and sum all n's and display fields from the 1's then the PK is the only thing you realy need. The rest will be from the 1 record anyway. So it's a lot of superflous work to check each non aggregate for changes. I found it to much work to redesign all the views etc and stuck with the old behaviour.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]