Hierarchical Cursors and Data Shaping

See Also   

You are familiar with visual controls, such as the File Open dialog box, that show folders and files in a hierarchical fashion. That's a good picture to keep in mind when you think about the new Hierarchical Cursor feature.

This feature allows you to define a child Recordset object as the value of a field in a parent Recordset. A typical application for this feature is to query "Customer" and "Order" databases, then display all the orders for each customer.

The new Shape data manipulation syntax built into the ADO Client Cursor Engine allows you to make queries that result in a hierarchical Recordset. You can then gain access to the child Recordset programmatically or through an appropriate visual control.