>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
>There is no GROUP BY in that sample. If it were you would have to have an aggregate function (like SUM()) to make sense and you would have to specify every field as per ANSI rules:
ex:
GROUP BY CODEMED,NOINTERNE,NAM,NOM,DATENAISS,CODEDIAG,HONOTOTAL,DATEMAJ
