AddDecimalParameter()


" "

short AddDecimalParameter(long QueryID, short Type, short Precision, short Scale, 
VARIANT Value, short Mode)

Description

This function is used for adding decimal parameters for a CALL statement. It applies the data in Value to a decimal variable in the CALL SQL 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.

Note:
The only valid value for AddDecimalHostVariable() is 484 (RSDT_DECIMAL).
Precision The precision of the decimal value.
Scale The scale of the decimal value.
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.