RowCount Property (Remote Data)

       

Returns the number of rows accessed in an rdoResultset object.

Syntax

object.RowCount

The object placeholder represents an object expression that evaluates to an object in the Applies To list.

Return Values

The RowCount property return value is a Long integer as discussed in Remarks.

Remarks

Use the RowCount property to find out how many rows in an rdoResultset object have been accessed, or if the rdoResultset returned any rows at all. RowCount doesn't indicate how many rows will be returned by an rdoResultset query until all rows have been accessed. After all rows have been accessed, the RowCount property reflects the total number of rows in the rdoResultset.

Referencing the RowCount property causes RDO to fully-populate the result set — just as if you had executed a MoveLast method.

Depending on the driver and data source, the RowCount property might return either -1 to indicate that the number of rows is not available, or 0 to indicate that no rows were returned by the rdoResultset. If the driver is capable of returning a row count, the RowCount property returns the number of rows in the rdoResultset.

Using the Requery method on an rdoResultset resets the RowCount property, just as it does when a query is run for the first time.