Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a field.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00546351
Message ID:
00547143
Views:
14
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
Map
View

Click here to load this message in the networking platform