Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQLBindParameter function

Binds a buffer parameter to a parameter marker in a SQL statement, for UltraLite ODBC.

UL_FN_SPEC SQLRETURN UL_FN_MOD SQLBindParameter (
SQLHSTMT StatementHandle,
SQLUSMALLINT ParameterNumber,
SQLSMALLINT ParamType,
SQLSMALLINT CType,
SQLSMALLINT SqlType,
SQLULEN ColDef,
SQLSMALLINT Scale,
SQLPOINTER rgbValue,
SQLLEN cbValueMax,
SQLLEN * StrLen_or_Ind );

• StatementHandle  A statement handle.

• ParameterNumber  The number of the parameter marker in the statement, in sequential order counting from 1.

• ParamType  The parameter type. One of the following:

  • SQL_PARAM_INPUT
  • SQL_PARAM_INPUT_OUTPUT
  • SQL_PARAM_OUTPUT

• CType  The C data type of the parameter.

• SQLType  The SQL data type of the parameter.

• ColDef  The size of the column or expression of the parameter marker.

• Scale  The number of decimal digits for the column or expression of the parameter marker.

• rgbValue  A pointer to a buffer for the parameter's data.

• cbValueMax  The length of the rgbValuergbValue buffer.

• StrLen_or_Ind  A pointer to a buffer for the parameter's length.

To exchange information between your application and the database, ODBC binds buffers in the application to database objects such as columns. SQLBindParameter is used when executing a statement, to identify a buffer in your application as a place that UltraLite gets or sets the value of a specified parameter in a query.

•  SQLBindParameter in the Microsoft ODBC Programmer's Reference.