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;




Reply With Quote