SQLBindParameter function

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

Syntax 
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 );
Parameters

  • 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.

Remarks

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.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1