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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere C API reference » sacapi.h


sqlany_num_rows function

Returns the number of rows in the result set.

sacapi_i32 sqlany_num_rows( a_sqlany_stmt * stmt )
  • stmt   A statement object executed by sqlany_execute or sqlany_execute_direct.


By default, this function only returns an estimate. To return an exact count, set the ROW_COUNTS option on the connection. For more information, see row_counts option [database].


The number of rows in the result set. If the number of rows is an estimate, the number returned is negative and the estimate is the absolute value of the returned integer. The value returned is positive if the number of rows is exact.

See also