Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trying to GROUP BY ....
Message
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 SP2
OS:
Windows 7
Database:
Visual FoxPro
Divers
Thread ID:
01531746
Message ID:
01531754
Vues:
32
>Simple workaround:
>
>
>SELECT max(cast (Dtyme as datetime)) AS DateTyme, AVG(DCreading) AS DCreading, ;
>	SPACE(10) AS cDate, SPACE(8) AS cHourMin, ROUND ((cast(dTyme as Datetime) - datetime(1900,1,1,0,0))/10,0)  as RoundedSec ;
>
>FROM CPdata  WHERE RType=[DC] ;
>	GROUP BY 5 ORDER BY 1 && VFP allows to use numbers in the GROUP BY and ORDER BY
>	INTO CURSOR CPchart  READWRITE
>>>&& round to 10 seconds.


Same error message. I'll have look at this again in a few days- right now I have other commitments. Thanks for your time.
Randy Bosma
VFP - Because life is too short to code in something else...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform