>>I'm trying to prepare a string to pass to the RMChart control. The string I'm attempting to build starts off as:
>>
>>m.lcData = "0*0*0*0*0*0*0*0*0*0*0*0*"
>>
>>
>>I have a table that stores a count of 'thingys' for a given month. There are two integer columns - the first value represents a month (1-12) while the second is the count of 'thingys'. The data in the table could look like this:
>>
>>mth cnt
>>4 129 (April has 129 occurences)
>>8 44 (August has 44 occurences)
>>12 1 (December has 1 occurence)
>>
>>
>>What I'd like to do is call some VFP string functions to have the string variable "adjusted" to look like this:
>>
>>m.lcData = "0*0*0*129*0*0*0*44*0*0*0*1*"
>>
>>
>>I've tried STRTRAN() in a scan loop but it fails to do what I need with the 4th parameter:
>>
>>STRTRAN(m.lcData, '0*', transform(cnt)+'*', mth, 1)
>>
>>
>>Anyone have a better idea?
>
>with STRTRAN() you should scan loop with the mth in DESC ORDER
Good one Fabio. Thanks.