fetching-rows-next-fetch-position.md

title	Next fetch position (OLE DB driver)
description	The OLE DB Driver for SQL Server keeps track of the next fetch position so that a sequence of calls to the GetNextRows method reads the whole rowset.
author	David-Engel
ms.author	davidengel
ms.date	06/14/2018
ms.service	sql
ms.subservice	connectivity
ms.topic	reference
ms.custom	ignite-2025
helpviewer_keywords	fetching rows OLE DB rowsets, fetching next fetch position rowsets [OLE DB], fetching

Fetching Rows - Next Fetch Position (OLE DB Driver)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]

[!INCLUDEDriver_OLEDB_Download]

The OLE DB Driver for SQL Server keeps track of the next fetch position so that a sequence of calls to the GetNextRows method (without skips, changes of direction, or intervening calls to the FindNextRow, Seek, or RestartPosition methods) reads the whole rowset without skipping or repeating any row. The next fetch position is changed either by calling IRowset::GetNextRows, IRowset::RestartPosition, or IRowsetIndex::Seek, or by calling FindNextRow with a null pBookmark value. Calling FindNextRow with a nonnull pBookmark value does not affect the next fetch position.

See Also

Fetching Rows