StayInSync Property (ADO)

      Applies To   

Indicates, in a hierarchical Recordset object, whether the parent row should change when the set of underlying child records (that is, a chapter) changes.

Settings and Return Values

Sets or returns a Boolean value. If set to True, the parent Recordset object will be updated if the chapter changes; if False, the parent Recordset object will continue to refer to the previous chapter.

Remarks

This property applies to hierarchical recordsets, such as those supported by the MSDataShape provider, and must be set on the parent Recordset before the child Recordset is retrieved. This property simplifies navigating hierarchical recordsets.