Share via

Fabricating Rowsets

  • Article

Important

This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, applications should use XML.

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