I have used the Utility (Calculatex)sucessfuly for single value fields. I recently tried to access a Multivalued field and the returned result was incorrect. I note that I have set the 5th parameter "MV" to zero.

In the AREV manual "Developer Series" the MV parameter is described as:

"The value number of the source value in a multivalued field. This value should be 0 (zero) if the field is single-valued"

What should the value of the MV field be if it is multivalued?

Any help will be appreciated.

Hi Mark

Lemme see if I have this right, bearing in mind I have never heard of the Calculatex utility. It isn't an any of the 3 arev manuals I have.

You have a multivalued field and your utility expects single values. The utility will accept a multivalued field with a pointer to the place in the multivalued list to the value to process, ie parameter 5.

So you could think of parameter 5 as list_pos.

Suppose your multivalued list looks like (where @VM is the delimiter)

rev_list=111@VM231@VM43.98@VM465AB34@VMFRED@VM675

Then to process 43.98 you would need to set

list_pos=3

Alternately you could use

single_value=rev_list

and use the utility as normal with parameter 5 set to zero.

If you wanted to process the whole list returing results in a corresponding multivalued list you'd need a loop to work through the positions in the array (list), and build up a new array with the results.

Hope you figure it out. If not, try posting more specific details about your utility, eg all the parameter details and some sample code for using it.

Scott

You can read the answer at http://www.revelation.com/WEBSITE/DISCUSS.NSF/f12696d31000b22a8525652b00831bb2/FA07EC4EC6F1FFA68525653E0066062C?OpenDocument

Thanks for the reply. It makes sense now.

Thanks Victor. The Sprez. article was most helpful.

Mark

View this thread on the forum...