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
>>
>>