Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error in SQL Request
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Error in SQL Request
Divers
Thread ID:
01056855
Message ID:
01056855
Vues:
56
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform