Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TRANFORM giving ***.** as a result
Message
De
19/05/2006 08:52:46
 
 
À
19/05/2006 08:50:30
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01123511
Message ID:
01123532
Vues:
20
Divide by zero?

>Update Again: I think I fixed it using "@Z" in the TRANSFORM function. Not sure why it didn't screw-up non-numeric fields, but it seems to work. Any enlightenment from anyone on the logic of this would be greatly appreaciated.
>
>>Update: If I add "999.99" to the TRANSFORM function, it displays correctly. Unfortunately, the whole idea of using this funtion was because the fields could be any type, not just numeric. I cannot simply add this paramter as it would screw up non-numeric type field values.
>>
>>
>>>Got a little routine that creates Excel and comma-delimited variables from the records in a cursor. I'm seeing one of the columns coming out in the results as "***.**" instead of "120.32" though other fields seem fine, regardless of their size. Is it something to do with the TRANSFORM function and the size of the first record's value (which is only "12.34")? Or something?
>>>
>>>
>>>
>>>PROCEDURE p_CreateDownloadFiles
>>>
>>>SCAN
>>>   FOR I = 1 TO FCOUNT()
>>>      m.CommaDelimitedData = m.CommaDelimitedData + '"' + TRANSFORM(EVALUATE(FIELD(I))) + '"' + IIF(I <FCOUNT(), ',', '' )
>>>      m.ExcelData = m.ExcelData + TRANSFORM(EVALUATE(FIELD(I))) + CHR(9)
>>>   NEXT
>>>   m.CommaDelimitedData = m.CommaDelimitedData + TCR_LF
>>>   m.ExcelData = m.ExcelData + TCR_LF
>>>ENDSCAN
>>>
>>>ENDPROC
>>>
>>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform