I’m sure this is a stupid question but I haven’t used forumla looping much…Why doesn’t this work?
n := 1;
cur := @GetField(“Item_” + @Text(n));
@While(
n <= 10;
@If(cur=“”; “”; cur);
n := n + 1)
I’m sure this is a stupid question but I haven’t used forumla looping much…Why doesn’t this work?
n := 1;
cur := @GetField(“Item_” + @Text(n));
@While(
n <= 10;
@If(cur=“”; “”; cur);
n := n + 1)
Subject: Will you check this for me?
Among other things, you need the
cur := @GetField(“Item_” + @Text(n));
inside the loop.
Subject: RE: Will you check this for me?
Thank you Ben. After a good nights sleep and a cup of coffee I figured it out…I was way off…
@For (n:=1; n<=10; n:=n+1;
@Do (
cur:=@GetField("Item_" + @Text(n));
temp:=temp : @If (cur = ""; ""; cur)
)
);
@Trim (temp)