>
>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
Add a space to the string "Pers. Natural " - this will give you the desired results. What's happening is the first record of the result is always evaluating to "Pers. Natural" for the tipo field, and VFP is making the size of the field based on that. Since the other string is one character longer, it is being truncated.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown