MDAC 2.5 SDK - OLE DB Providers
Data Shaping Service for OLE DB


 

Fabricating Rowsets

Using the Shape language, it is possible to construct empty rowsets that contain specific column types. These rowsets can be used to build hierarchies for prototyping or testing.

In the connection string, use the keywords "Provider=MSDataShape;data provider=None" to invoke the Shaping Provider but not a data provider.

Use the Shape keyword NEW in the APPEND clause to create new columns in the rowset, as in the following example:

SHAPE 
   APPEND
      NEW DBTYPE_I4 AS Cust_LocationCode,
      NEW adLongVarChar AS Cust_Country,
      NEW adChar(60) AS Cust_Address