Summary
This chapter introduced and explained the concepts of Data Shaping and Hierarchical Recordset with the use of the Microsoft Data Shaping Service provided with ADO 2.0 and 2.1, how to create Shaped statements, and how to use them in your applications. After reading this chapter, you should be able to connect to the MS Data Shaping Service and fully understand the Shape command syntax and the following key points about it:
There are two types of Shape commands: APPEND and COMPUTE.
The APPEND Shape command allows you to append a child recordset to a parent recordset.
The COMPUTE Shape command allows you to create a parent recordset to a child recordset based upon computations specified in the Shape statement.
Shape commands can be nested to any level that you need.
Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
