Help Center
/
Help Center›AfxNova›CODBCStmt Class

CODBCStmt.SetStmtRowArraySizemethod

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

DatabasesmethodCODBCStmt.incdocumented

Syntax

FUNCTION SetStmtRowArraySize (BYVAL dwAttr AS SQLUINTEGER) AS SQLRETURN

Parameters

NameDescription
dwAttrThe number of rows.

Return value

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

Result value (GetLastResult)

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

Description

Sets 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:1835
  • Documented in Databases/ODBC Classes/CODBCStmt Class.md
  • Topic: CODBCStmt Class