Syntax

You can use the following generic method on the Progress.Open4GL.Proxy.ParamArray class to set the parameters in the ParamArray:

public void AddParameter(Int32 position, Object value, Int32 mode, 
                         Int32 proType, Int32 extentValue,
                         Progress.Open4GL.DynamicAPI.MetaDataBase metaData)
position

Specifies a 0-based index indicating the parameter position.

value

Specifies a variable of the appropriate Object data type that contains the value for the parameter, or null for an OUTPUT parameter.

mode

Specifies the ABL mode (passing direction) of the parameter. This can be one of the following constant values:

  • ParamArrayMode.INPUT
  • ParamArrayMode.INPUT_OUTPUT
  • ParamArrayMode.OUTPUT
proType

Specifies the ABL data type of the parameter indicated by a class constant defined in the Progress.Open4GL.Parameter class, as shown in the following table.

Table 1. ABL parameter data types for the OpenAPI
ABL data type Progress.Open4GL.Parameter class constant 
CHARACTER
 
PRO_CHARACTER
 
COM-HANDLE
 
PRO_COMHANDLE 
DATASET
 
PRO_DATASET
 
DATASET-HANDLE
 
PRO_ DATASETHANDLE
 
DATE
 
PRO_DATE
 
DATETIME
 
PRO_DATETIME
 
DATETIME-TZ
 
PRO_DATETIMETZ
 
DECIMAL
 
PRO_DECIMAL
 
HANDLE 
PRO_WIDGETHANDLE
 
INT64
 
PRO_INT64
 
INTEGER
 
PRO_INTEGER 
LOGICAL
 
PRO_LOGICAL
 
LONGCHAR
 
PRO_LONGCHAR
 
MEMPTR
 
PRO_MEMPTR
 
RAW
 
PRO_RAW
 
RECID
 
PRO_RECID
 
ROWID
 
PRO_ROWID 
TEMP-TABLE
 
PRO_TEMPTABLE
 
TABLE-HANDLE
 
PRO_TABLEHANDLE
 
WIDGET-HANDLE 
PRO_WIDGETHANDLE
extentValue

Specifies the extent of an array, 0 or 1 for a scalar value.

metaData
Specifies the schema for ProDataSet or temp-table parameters, where proType is one of the following:
  • Parameter.PRO_DATASET
  • Parameter.PRO_DATASETHANDLE
  • Parameter.PRO_TEMPTABLE
  • Parameter.PRO_TABLEHANDLE

    The value can be specified using one of the following classes:

  • TempTableMetaData — Defines the schema information for temp-table parameters or temp-tables in a ProDataSet. For more information on defining this schema, see Define the schema for a temp-table parameter.
  • ProDataSetMetaData — Defines the schema information for ProDataSet parameters. For more information on defining the schema for ProDataSet parameters, see Define the schema for a ProDataSet parameter.

When mode is ParamArrayMode.OUTPUT and proType is Parameter.PRO_DATASETHANDLE or Parameter.PRO_TABLEHANDLE (passing a dynamic ProDataSet or temp-table parameter), you can set this parameter to null.