Hi Mike,
What about using Stuff()?
m.lcData = "0*0*0*0*0*0*0*0*0*0*0*0*"
create cursor c_test (month I, cnt I)
insert into c_test values (4, 129)
insert into c_test values (8, 44)
insert into c_test values (12, 1)
scan
m.lcData = Stuff(m.lcData, At('*', m.lcData, c_test.month) - 1, 1, Transform(c_test.cnt))
endscan
? m.lcDataOr you can build the string from scratch, not sure which is better.
[Update]
Building from scratch would be like this
lcData = ''
go top in c_test
for lnMonth = 1 to 12
if lnMonth = c_test.month
lcData = lcData + Transform(c_test.cnt) + '*'
skip in c_test
else
lcData = lcData + '0*'
endif
next lnMonth
? m.lcData
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
