General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only