i have a formula field. Here is the code:
if {tblJobs.scflist} is null then i get no result. it will not process anything after the for loop. how can i get around this?Code:stringVar array x1 := "";
stringVar result := "";
numberVar i;
numberVar top := ubound(split({tblJobs.scflist},'|'));
for i := 1 to top do
(
redim preserve x1[i];
x1[i] := split({tblJobs.scflist},'|')[i];
result := result + x1[i];
result := result + chr(10);
);
if {tblJobs.choosescf} and result = "" then "Please Advise" else result;
