AddParameter()


" "

short AddParameter(long QueryID, short Type, VARIANT Value, short Mode)

Description

This function is used for adding non-decimal parameters for a CALL statement and applies the data in Value to a variable in the CALL statement initialized with QueryID.

Parameters


Name Description
QueryID The ID of the query, as returned from InitializeStaticQuery() or InitializeQuery().
Type

The SQL data type of the value to be passed to the database server. This value influences the conversion of Value from a VARIANT data type to the value actually passed. The valid data types are:

  • LOB data types
  • LOB locator data types
  • RowID data types
  • Data Link data types
  • Bigint data types

Value The data value to substitute in the statement. To specify a null value, set the variant type to VT_EMPTY.
Mode

The mode of the parameter. The valid values for Mode include:

  • 0 (RSPM_IN) for input
  • 1 (RSPM_OUT) for output
  • 2 (RSPM_INOUT) for input and output parameters

Return Value

The return value will be zero if successful or non-zero if unsuccessful. If the return value is non-zero, you can call GetLastErrorString() or GetLastErrorType() to get additional error information.