>>Is there any way where we can have functions in groupby while firing a SQL statement to visual foxpro.
>>
>>Eg: select jobno,year(eta) from jobmast group by year(eta)
>>
>>The above SQL gives an error. THe roundabout way is
>>
>>select jobno,year(eta) as yr from jobmast group by yr
>>
>>The above SQL Statement works fine, but the OLAP tool which connects to visual foxpro database generates the 1st SQL statement. And the report dosen't go through.
>>
>>Regards
>>Ravi
>
>The group by needs to be one of the fields in the select's field list. The >first one would work if it was group by 2 instead.

Mark,

I am using Business Objects to generate SQL and BO generates the SQL as the first one. I am wondering if vfp can work based on the first method.
Regards
Ravi