Xojo Documentation Xojo Documentation

Method

RowSet.RowCount() As Integer

New in 2019r2

Supported for all project types and targets.

The number of rows in the RowSet.

Notes

Currently only supported by these databases:

• SQLiteDatabase
• PostgreSQLDatabase
• OracleDatabase
• ODBCDatabase, although not all ODBC drivers implement this

For databases that do not support this function, an UnsupportedOperationException is raised.

Sample Code

Display the row count if it is available:

// rs is a RowSet
Try
Label1.Value = "Rows: " + rs.RowCount.ToString
Catch e As UnsupportedOperationException
Label1.Value = e.Message
End Try