>Thanks ahead of time for the help. I am converting a VFP6 app to a VFP9 app and this SQL Select statement gives an error -> "SQL: GROUP BY clause is missing or invalid."
>
>This is the code.
>
>
>
>IF llDifObjName
> SELECT ;
> PADR(ALLTRIM(mLibPath)+ALLTRIM(cLibName),254) AS LibName, ;
> cClassName, ;
> cObjName, ;
> MAX(tLastUpdt) ;
> FROM ;
> (this.cRegistryName) ;
> WHERE ;
> UPPER(cProdName) ** "SYSTEM RECORD" AND ;
> NOT DELETED() ;
> GROUP BY ;
> cProdName ;
> INTO ARRAY laLibList
ENDIF && WAS MISSING
>The ** is greater than less than symbols. Email won't send them!!!
>
>I have tried several ways to rearrange the Select statements order and such but it still blows when I run the app. Any Ideas?
>
>Thanks,
>
>John King