Shape APPEND Clause

The shape command APPEND clause appends a column or columns to a Recordset. Often these columns are chapter columns, which refer to a child Recordset.

Syntax

SHAPE [parent-command [[AS] parent-alias]] APPEND column-list

Description

The parts of this clause are as follows:

parent-command

Zero or one of the following (you may omit the parent-command entirely):

• A provider command within curly braces ("{}") that returns a Recordset object. The command is issued to the underlying data provider, and its syntax depends on the requirements of that provider. This will typically be the SQL language, although ADO does not require any particular query language.
• Another shape command embedded in parentheses.
• The TABLE keyword, followed by the name of a table in the data provider.

parent-alias

An optional alias that refers to the parent Recordset.

column-list

One or more of the following:

• An aggregate column.
• A calculated column.
• A new column created with the NEW clause.
• A chapter column. A chapter column definition is enclosed in parentheses ("()"). See syntax below:

SHAPE [parent-command [[AS] parent-alias]]
   APPEND (child-recordset [ [[AS] child-alias] 
      RELATE parent-column TO child-column | PARAMETER param-number, ... ])
   [[AS] chapter-alias] 
   [, ... ]

child-recordset

• A provider command within curly braces ("{}") that returns a Recordset object. The command is issued to the underlying data provider, and its syntax depends on the requirements of that provider. This will typically be the SQL language, although ADO does not require any particular query language.
• Another shape command embedded in parentheses.
• The name of an existing shaped Recordset.
• The TABLE keyword, followed by the name of a table in the data provider.

child-alias

An alias that refers to the child Recordset.

parent-column

A column in the Recordset returned by the parent-command.

child-column

A column in the Recordset returned by the child-command.

param-number

See Operation of Parameterized Commands.

chapter-alias

An alias that refers to the chapter column appended to the parent.

Note   The "parent-column TO child-column" clause is actually a list, where each relation defined is separated by a comma.

Note    The clause after the APPEND keyword is actually a list, where each clause is separated by a comma and defines another column to be appended to the parent.

See Also

Data Shaping | Formal Shape Grammar | Shape Commands in General

© 1998-2001 Microsoft Corporation. All rights reserved.