>>can someone tell me why this SQL request doesn't work in VFP8 ??? I got an error on ther "GROUP BY" clause
>>
>>

>>SELECT CODEMED,NOINTERNE,NAM,NOM,DATENAISS,CODEDIAG,HONOTOTAL,DATEMAJ;
>>	from factcur;
>>	WHERE ((FACTCUR.STATUSFACT = "F") .AND.;
>>		  (AT("B",FACTCUR.CONSSPECIA)<>0) .AND.;
>>		  !EMPTY(FACTCUR.DATEMAJ) .AND.;
>>		  BETWEEN(FACTCUR.DATEMAJ,M_DATDEB,M_DATFIN)) .AND.;
>>		  BETWEEN(FACTCUR.CODEMED, M_MEDDEB, M_MEDFIN);
>>union ;
>>select CODEMED,NOINTERNE,NAM,NOM,DATENAISS,CODEDIAG,HONOTOTAL,DATEMAJ;
>>	from facthisto ;
>>	WHERE ((FACTHISTO.STATUSFACT = "F") .AND.;
>>		  (AT("B",FACTHISTO.CONSSPECIA)<>0) .AND.;
>>		  !EMPTY(FACTHISTO.DATEMAJ) .AND.;
>>		  BETWEEN(FACTHISTO.DATEMAJ,M_DATDEB,M_DATFIN)) .AND.;
>>		  BETWEEN(FACTHISTO.CODEMED, M_MEDDEB, M_MEDFIN) ;
>>order by codemed,DTOCdatemaj ;
>>INTO CURSOR facttmp
>>

>
>Thierry,
>
>Not sure if its just a typo in your post or not, but you have DTOCdatemaj instead of DTOC(datemaj). Also, you might get a better result using DTOS(datemaj).
>
>Regards,

sorry... it's a typo, you should read "ORDER BY Codemed, DateMaj" and the error is not on "GROUP BY" clause, but on "ORDER BY"