>1. Visual FoxPro no longer supports using the DISTINCT clause in a SQL SELECT statement that contains Memo or General fields.
>2. The GROUP BY query are conistent with MS SQL Server and other backends. The only columns allowed are the ones in the GROUP BY or aggregate functions. So following query is invalid in VFP8
SELECT filed1, filed2, field3, COUNT(*) ;
> FROM mytabele ;
> GROUP BY 1,2
There is new SYS(3099) function that controls database engine comatibility level.
I can't seem to get the GROUP BY to go wrong on mine, is there something i'm missing?
Kev
>
>>>There are significant changes in database engine related to SELECT - SQL.
>>
>>What sort of changes? Could you list any important ones?
>>
>>Thanks
>>Kev
>>
>>>>
>>>>Has anyone attempted this? Has MS mentioned anything about it?
>>>>
>>>>Thanks
>>>>Kev