Visual Basic Concepts

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 .

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 , 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.