I know this problem as I often work with SQl server ... which works the same way.
>>Does this mean it's buggy ?
>>
>>>>
>>>>I thought 9.0 was still in beta ?
>>>>
>>>
>>>see my reply
>>>
>>>+
>>>.... however thinking about it, I somtimes have the feelin it still is ;-)
>
>I think there is a service-pack to come ;-) I think it's ok but I remember having some issues with inheritance
>
>One thing that will probably hit You when changing from 5 to 8 (or 9): In accordance to the ANSI-Standard the "Group by" clause has been changed.
>
>the new syntax requires that the group by clause contains "every" field You have in "select field1, field2, field3....", except calculated fields. This is something noone of us ever did (and sometimes returns completely different results). However You will receive an error if You don't (Invalid Group statement).
>
>This can be a nightmare, wenn migrating. So probably the best thing You can do (at least to get You going quickly) is to issue
>
>
>set EngineBehavior 70
>
>
>in Your startup-program. Then VFP will behave as You expect. And You have some time to change Your SQL's
>
>But the step from 5 to either 8 or 9 will give You soooo much, I'll promise