errors in array and for loop

[ub1234567]

hi everyone,

this is not same thread, this is my different problem.

stringvar a := "";
numbervar i;
numbervar b := array({?subcat - ProductSubcategoryID})
for i := 1 to count({?subcat - ProductSubcategoryID})
step 1
do
a := a & b
a;

above code given me error - number,currencr,datetime,string is expected here.

any help is appriciated

thanks.

 

[IanWaterman]

YOu have not defined this properly

numbervar b := array({?subcat - ProductSubcategoryID})

this does not make sense

also you can not concatenate numbers and strings, you will have to convert number to a string first using totext()

if this ({?subcat - ProductSubcategoryID}) is an array of numbers then try

numbervar array b := ({?subcat - ProductSubcategoryID})

Ian

 

[scottostanek]

Making assumptions since you didn't specify -- you have a list of things that are numbers that you need to concatenate without the character mixed in. I have had similar needs when dealing with a GL number formatted as xxx-xxxx-xx-xx-xxxx or something like that... lol

numbervar array b :=
split({?subcat - ProductSubcategoryID},"-");
//assumes dash delimted, replace with whatever
for i := 1 to ubound(b)
a := a & b
a;

Is this what you were after?
Scotto the Unwise