>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