stayinsync-property.md

title	StayInSync Property | 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	Recordset20::StayInSync Recordset20::put_StayInSync Recordset20::PutStayInSync Recordset20::get_StayInSync Recordset20::GetStayInSync
helpviewer_keywords	StayInSync property
ms.assetid	502d69b5-dc9a-455d-b115-a03bd39a552b
author	MightyPen
ms.author	genemi

StayInSync Property

Indicates, in a hierarchical Recordset object, whether the reference to the underlying child records (that is, the chapter) changes when the parent row position changes.

Settings and Return Values

Sets or returns a Boolean value. The default value is True. If True, the chapter will be updated if the parent Recordset object changes row position; if False, the chapter will continue to refer to data in the previous chapter even though the parent Recordset object has changed row position.

Remarks

This property applies to hierarchical recordsets, such as those supported by the Microsoft Data Shaping Service for OLE DB, and must be set on the parent Recordset before the child Recordset is retrieved. This property simplifies navigating hierarchical recordsets.

Applies To

Recordset Object (ADO)

See Also

StayInSync Property Example (VB)
Microsoft Data Shaping Service for OLE DB (ADO Service Provider)