Information générale
Catégorie:
Codage, syntaxe et commandes
SELECT substr(dtos(ADDDATE),6) as yearmonth, * ;
FROM THREAD;
WHERE NOMEMBER=lnNumero AND NOCLIENT=lnWeb;
INTO CURSOR TEMP;
ORDER BY 1
Now you have the repartition and you can select any yearmonth from TEMP.
As long as you take all dates from THREAD for a specified user, you don't need the 1st and last date in the SELECT.
Vlad
>SELECT ADDDATE FROM THREAD;
> WHERE NOMEMBER=lnNumero AND NOCLIENT=lnWeb;
> ORDER BY 1 INTO CURSOR TEMP
>
>This will be a direct result giving me all the dates for a user in a specify forum. So, after this SQL, I now have my first date. Doing GO BOTTOM, will give the last date.
>
>There I have the first and last date which I then use for the month/year repartition.
>
>This is where I am not sure about the technique to use.
>
>Thanks.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement