RecordsReturned64 Property

Gets the number of rows returned from the execution of a SELECT statement.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public ReadOnly Property RecordsReturned64 As Long

'Usage
 
Dim instance As TdDataReader
Dim value As Long
 
value = instance.RecordsReturned64

public long RecordsReturned64 {get;}

public:
property int64 RecordsReturned64 {
   int64 get();
}

Property Value

The records returned from a select statement.

Remarks

The RecordsReturned64 property reflects the activity count of a SELECT statement. The activity count is the number of rows selected. For all other statements this property will be 0.

If the number of rows returned is less than or equal to Int32.MaxValue, both RecordsReturned and RecordsReturned64 properties will return the same value.

If the number of rows returned from the execution of select statement overflows Int64.MaxValue, Int64.MaxValue value will be returned. The provider will post an event to TdConnection.InfoMessage when an overflow condition occurs. The event will include a warning code and message. The warning message will have the actual number of records returned. The message code is 114003 and the message text is "An overflow occurred while calculating the number of records returned, actual value is [RecordsReturned]"

NOTE: In order for an application to be aware that an overflow occurred, it must register for the callback with TdConnection.InfoMessage event. Refer to TdDataReader.RecordsReturned for an example.

This property is not cumulative. If multiple SELECT statements are contained in a multi-statement request, the RecordsReturned64 will only contain the activity count of the current result set.

Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

Reference

TdDataReader Class
TdDataReader Members