Multiple Value Procedure Prompts


If a list is used as input for a pre- or post-update procedure, the procedure is run as many times as the number of values in the list. If lists of different lengths are used at the same time, one of two things will happen depending on the length of the lists.

 

Example 1:

If one of the lists contains only one value, that value will be distributed to the values of the other list.

 

List X: [1,2,3]

List Y: [A       ]

 

Result: First call procedure with parameters: 1,A

Then: 2,A

Then: 3,A

 

Example 2:

If both lists contain more than one value, the values of the shorter list will be distributed to the values of the longer list, and null will be added to the remaining values.

 

List X: [1,2,3]

List Y: [A, B  ]

 

Result: 1,A

2,B

3,null

 

A query procedure does not accept a list as input, only a single value.

See also:

Creating a Pre- or Post-procedure