| title | FetchProgress Event (ADO) | Microsoft Docs | ||
|---|---|---|---|
| ms.prod | sql | ||
| ms.prod_service | connectivity | ||
| ms.technology | connectivity | ||
| ms.custom | |||
| ms.date | 01/19/2017 | ||
| ms.reviewer | |||
| ms.topic | conceptual | ||
| apitype | COM | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 301716fd-81fc-40eb-8a04-221ef7ab410e | ||
| author | MightyPen | ||
| ms.author | genemi |
The FetchProgressevent is called periodically during a lengthy asynchronous operation to report how many more rows have currently been retrieved into the Recordset.
FetchProgress Progress, MaxProgress, adStatus, pRecordset
Progress
A Long value indicating the number of records that have currently been retrieved by the fetch operation.
MaxProgress
A Long value indicating the maximum number of records expected to be retrieved.
adStatus
An EventStatusEnum status value.
pRecordset
A Recordset object that is the object for which the records are being retrieved.
When using FetchProgress with a child Recordset, be aware that the Progress and MaxProgress parameter values are derived from the underlying Cursor Service rowset. The values returned represent the total number of records in the underlying rowset, not just the number of records in the current chapter.
Note
To use FetchProgress with Microsoft Visual Basic, Visual Basic 6.0 or later is required.