The effect is that each time the parent command moves to a new row and you request the column requesting the chapter Recordset, the child SQL is issued. Data shaping is a powerful technique when you have data that has hierarchical relationships. A shaped recordset lets you work with the data that has parent-child relationships without having to write code to implement the relationships. For instance, if you delete a parent record from a shaped recordset, data shaping will delete the child records, even if the underlying database doesn't support cascading deletes. All rights reserved.
Consumers are objects or applications that use data provided by the other two kinds of objects.
A provider is an object that can extract data from a data source and return it in the standard ADO format. A service provider can't extract data, but, like a consumer, it can accept data from a provider. A service provider, unlike a straight consumer, also manipulates the data and can pass it on to a consumer or another service provider. Since a service provider can work with any ADO provider, service providers can be very flexible. Since the Index Server data provider returns data in the standard ADO format, you can use the Data Shaping server to manipulate that data.