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

SQL Anywhere 11.0.1 (Français) » UltraLite - C and C++ Programming » API Reference » UltraLite C++ API reference » UltraLite_Cursor_iface class


GetRowCount function

Gets the number of rows in the table.

ul_u_long UltraLite_Cursor_iface::GetRowCount(
      [ ul_u_long threshold ]
  • threshold   Optional parameter setting a threshold number of rows to count. If threshold is supplied and is greater than zero, the maximum row count returned is the threshold value. The actual number of rows may be equal to or greater than the threshold value.


Setting a threshold value to limit the number of rows to count can be useful in situations where it is important to know if more than a specific number of rows exist. For example, code that is populating a list that holds 25 items can determine whether it is necessary to permit the user to have an option to view additional rows.

Calling this method is equivalent to executing "SELECT COUNT(*) FROM table".