| Previous | Next |
| ERROR_COMPRESSION_DISABLED | ERROR_CANTSCROLLBACKWARDS |
ERROR_CANTFETCHBACKWARDS
the data provider cannot fetch rows in the backward direction.
ERROR_CANTFETCHBACKWARDS identifies this condition: A rowset or provider was asked to retrieve earlier rows, but its cursor implementation is forward-only or the requested access pattern is unsupported.
Where the result appears
- OLE DB and cursor-style data providers.
- streaming result sets.
- large queries optimized for forward scanning.
- UI grids attempting reverse pagination.
What to collect
- provider and cursor properties.
- requested row offset and count.
- whether rows were released.
- query ordering and bookmark support.
Handling and recovery
Use a scrollable cursor only when the provider advertises it. Otherwise cache the required rows in the client, restart the query at a known key, or redesign pagination around stable forward bookmarks.
Common misinterpretation
Repeatedly issuing the same negative offset cannot add provider capability. The fix is capability negotiation or a different navigation strategy.
References
Looking for a different code? Search another status or error code.