hi i am quite new with this one and i am having a problem with the following…
i have a field (multivalue separated with newlines) that gets its value from two dblookups… sample code.
2008 := @DbLookup(“”:“NoCache”;2008server:20008db;view;SNO;2;[FailSilent]);
2007 := @DbLookup(“”:“NoCache”;2007server:2007db;view;SNO;2;[FailSilent]);
2008 returns a1, a2, a3.
2007 returns b1, b2, b3.
Now, i want these values to be included in my multivaluefield, year. Using the following code:
FIELD year:=@If(2008=null & 2007=null;“No info.”; 2008 + 2007);
i get these values for my field:
a1b1
a2b2
a3b3
i wanted my field to display the following:
a1
a2
a3
b1
b2
b3
and i used this code and it did display the desired result (not sure though if this is the RIGHT code):
FIELD year:=@If(2008=null & 2007=null;“No info.”; @implode(2008; @newline) + @newline + @implode(2007;@newline));
although it does display my desired result, i wanted to know how many elements are displayed on the field in total. to my dismay, elements function, i think, returns a blank value.
i wanted to know the total number of elements stored in the field and how do i access each field (like for example, i need to access b2’s document). hope you could help! i think i used the wrong codes…
