FairCom Direct SQL for C and C++

ctsqlSetNumericParameter

Declaration

CTSQLRET ctsqlDECL ctsqlSetNumericParameter(pCTSQLCMD hCmd, INTEGER index, CTSQLTYPE ptype, BIT isnull, NUMERIC* buffer);

Description

Sets a Numeric value for a parameter.

• hCmd the command handle.
• index the parameter number to be set. The value must be greater or equal to zero but less than the parameter count.
• ptype the type of parameter being passed in buffer. This type must match the expected type.
• isnull TRUE indicates a NULL value.
• buffer buffer containing the parameter value. buffer can be NULL if isnull is TRUE.

Return Values

ctsqlSetParameter() return CTSQLRET_OK on success.

Symbolic Constant	Explanation
SQL_ERR_BADPARAM	Bad parameter specification for the statement.
SQL_ERR_INTYPES	Inconsistent types.

See Also

ctsqlSetIntegerParameter(), ctsqlSetBigIntParameter(), ctsqlSetFloatParameter(), ctsqlSetDateParameter(), ctsqlSetTimeParameter(), ctsqlSetTimeStampParameter(), ctsqlSetNCharParameter(), ctsqlSetBinaryParameter()