Command Hierarchies

A Command hierarchy is a group of recordset-returning Command objects that define an ADO hierarchical Recordset. Once a Command hierarchy is established, the Data Environment designer builds an ADO SHAPE Command, which is executed at run time and results in an ADO hierarchical Recordset. For more information, see Data Shaping.

The Data Environment designer provides an easy-to-use interface to create ADO Recordset hierarchies. You can build relation hierarchies, grouping hierarchies, and aggregate calculations. Once a hierarchy is built, at run time, you can navigate through multiple Recordsets as a single unit or bind each Recordset object to controls on a form.

You can use the Microsoft Hierarchical FlexGrid control to display the data from all the recordsets in the hierarchy at one time in a banded format. You can also bind the hierarchical recordset to a set of controls on a form, as described in Binding Data to Your Data Environment.