CreateArrayAny
Mon 01 January 2018Syntax
CreateArrayAny([paramlist])
Where paramlist is an arbitrary-length list of values in the form:
param1 [, param2] ...
Description
Use the CreateArrayAny function to construct an array whose elements are of data type ANY and returns a reference to it.
The CreateArrayAny function uses flattening and promotion as required to convert subsequent values into suitable elements of the array.
If you do not specify any parameters with CreateArrayAny, it's the same as using the CreateArray function without any parameters.
If you do not know how many values are needed in a SQL statement until runtime, you can use an array of any to supply the values.
Parameters
Field or Control |
Definition |
---|---|
paramlist |
Specify a list of values to be used as the elements of the array. |
Returns
Returns a reference to an array of ANY.