>Is there any particular reason why you use TRANSFORM() instead of ALLTRIM(STR())? I just searched the MS Knowledge Base and found the following article that mentions some problems with TRANSFORM(): Q247494. I've just always used ALLTRIM(STR()), and never really looked at anything else, so I didn't know if there was a benefit to using TRANSFORM() other than less typing.
One function instead of two, and also look to the difference between:
lnNumber=2.345678901
?transform(lnNumber)
?alltrim(str(lnNumber))
>>>There may be a better way, but of the top of my head:
>>>
>>>ALLTRIM(STR(VAL( LEFT( oJC.IssMonth, 2 ) )))
>>
>>Hi Jonathan,
>>
>>With VFP6.0 I make a habit to use transform() instead of alltrim(str())
>>
>>
>>>>Hi everybody,
>>>>
>>>>I have this string in my report:
>>>>SUBSTR(oJC.IssMonth,3) +' YEAR-TO-DATE RECAP THRU ISSUE ' +LEFT(oJC.IssMonth,2)
>>>>
>>>>left(oJC.IssMonth,2) would be '07', '08', etc. I would like to print just '7' or '8' in my Report. What would be the simplest way to achive this?
>>>>
>>>>Thanks.
If it's not broken, fix it until it is.
My Blog