Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select does not support the quarter function
Message
 
 
À
12/05/2006 15:36:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01121405
Message ID:
01121472
Vues:
17
You cannot GROUP or ORDER on expression
	         group by taxliab.clientno, year, qtr, taxliab.duedate ;
	         order by taxliab.clientno, year, qtr, taxliab.duedate ;
>	select taxliab.clientno as clientno, ;
>		   YEAR(taxliab.chkdate) as year, QUARTER(taxliab.chkdate) as qtr, ;
>	       taxliab.duedate as duedate, ;
>	       sum(taxliab.amount-taxliab.credtaken-taxliab.removed) as amount, ;
>	       client.eftpscode as pin, client.fedid as fedid, ;
>	       lcfirsttaxtype as taxtype, lccode as code ;
>			 from taxliab, client ;
>	         where taxliab.clientno == client.clientno and ;
>	         	   taxliab.taxtype $ lctaxtype and ;
>	         	   taxliab.duedate <= lddate and ;
>	               taxliab.status == 'P' ;
>	         group by taxliab.clientno, YEAR(taxliab.chkdate), QUARTER(taxliab.chkdate), taxliab.duedate ;
>	         order by taxliab.clientno, YEAR(taxliab.chkdate), QUARTER(taxliab.chkdate), taxliab.duedate ;
>	         into cursor tcdata readwrite
>
>
>
>this does not work
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform