>I get the above message with the following sql statement:
>
>> SELECT MAX(trackrcd.date), ALLTRIM(trackrcd.t_s_num) FROM trackrcd ;
> WHERE ALLTRIM(trackrcd.client_id) == thisform.idclient AND;
> ALLTRIM(trackrcd.prjt_num) == thisform.idproj AND ;
> ALLTRIM(trackrcd.task_num) == thisform.idtask ;
> INTO ARRAY datearray
>
>
>Anyone know why? This is not a group by situation.Because of MAX()
Aggregate functions require grouping. Would not make sense otherwise (ANSI).
Also, returning ALLTRIM(trackrcd.t_s_num) may give you incomplete results as VFP will return a field length based on the length of the first item found. Try PADding it or in VFP9 using CAST().