CODBCStmt.GetStmtRowArraySizemethod

Gets an SQLUINTEGER value that specifies the number of rows returned by each call to **Fetch** or **FetchScroll**.

Syntax

FUNCTION GetStmtRowArraySize () AS SQLUINTEGER

Return value

The number of rows returned by each call to Fetch or FetchScroll.

Result code (GetLastResult)

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

Description

Gets an SQLUINTEGER value that specifies the number of rows returned by each call to Fetch or FetchScroll. It is also the number of rows in a bookmark array used in a bulk bookmark operation in BulkOperations. The default value is 1.

Remarks

If the specified rowset size exceeds the maximum rowset size supported by the data source, the driver substitutes that value and returns SQLSTATE 01S02 (Option value changed).

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

Reference

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