CODBCStmt.SetStmtRowBindTypemethod

Sets an SQLUINTEGER value that sets the binding orientation to be used when **Fetch** or **FetchScroll** is called on the associated statement.

Syntax

FUNCTION SetStmtRowBindType (BYVAL dwAttr AS SQLUINTEGER) AS SQLRETURN

Parameters

Return value

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

Description

Sets an SQLUINTEGER value that sets the binding orientation to be used when Fetch or FetchScroll is called on the associated statement. Column-wise binding is selected by setting the value to SQL_BIND_BY_COLUMN. Row-wise binding is selected by setting the value to the length of a structure or an instance of a buffer into which result columns will be bound.

Remarks

If a length is specified, it must include space for all of the bound columns and any padding of the structure or buffer to ensure that when the address of a bound column is incremented with the specified length, the result will point to the beginning of the same column in the next row. When using the sizeof operator with structures or unions in ANSI C, this behavior is guaranteed.

Column-wise binding is the default binding orientation for Fetch and FetchScroll.

Setting this statement attribute sets the SQL_DESC_BIND_TYPE field in the ARD header.

Reference

• Include file CODBCStmt.inc
• Defined in AfxNova/COdbcStmt.inc:1861
• Documented in Databases/ODBC Classes/CODBCStmt Class.md
• Topic: CODBCStmt Class