Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Thank for your reply Wayne.
You know, I was testing it, but I have other problem the suject is that the field that I`m adding due to this no get all the information that I put it there.
This is the code:
SELECT CTOD(SUBSTR(STR(fechlo,8,0),7,2)+"/"+SUBSTR(STR(fechlo,8,0),5,2)+"/"+SUBSTR(STR(fechlo,8,0),1,4)) AS fecha,;
iif(alltr(proglo)#"BODPJIDH","Pers. Natural","Pers. Juridica") AS tipo,;
"Hist. Conexiones" AS indicador,;
COUNT(Conexiones_historico.fechlo) AS transxdia;
FROM "datos!conexiones historico" Conexiones_historico;
GROUP BY Conexiones_historico.fechlo, Conexiones_historico.proglo;
INTO TABLE dbfstmp\conhist.dbf
When I check out the information in the fields indicador the information appears cut, I mean "Pers. Juridic".
I have change the posicion of the information, put just "Juridica", the logic validation, but any thing of this resolve the problem.
Do you know, where is the mistake.?
TIA
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