正式な Shape 文法

次に、すべての Shape コマンドの作成における正式な文法を示します。

その他のすべての項はリテラルです。

定義
<shape-command>

SHAPE [<table-exp> [[AS] <alias>]][<shape-action>]
<table-exp>

{<native-sql-statement>} |
(<shape-command>) |
TABLE <quoted-name> |
<quoted-name>
<shape-action>

APPEND <aliased-field-list> | 
COMPUTE <aliased-field-list> [BY <field-list>]
<aliased-field-list>

<aliased-field> [, <aliased-field...>]
<aliased-field>

<field-exp> [[AS] <alias>]
<field-exp>

(<relation-exp>) |
<calculated-exp> |
<aggregate-exp> |
<new-exp>
<relation_exp>

<table-exp> [[AS] <alias>] 
    RELATE <relation-cond-list>
<relation-cond-list>

<relation-cond> [, <relation-cond>...]
<relation-cond>

<field-name> TO <child-ref>
<child-ref>

<field-name> | 
PARAMETER <param-ref>
<param-ref>

<number>
<field-list>

<field-name> [, <field-name>]
<aggregate-exp>

SUM(<qualified-field-name>) |
AVG(<qualified-field-name>) |
MIN(<qualified-field-name>) |
MAX(<qualified-field-name>) |
COUNT(<alias> | <qualified-field-name>) |
STDEV(<qualified-field-name>) |
ANY(<qualified-field-name>) 
<calculated-exp>

CALC(<expression>)
<qualified-field-name>

<alias>.[<alias>...]<field-name>
<alias>

<quoted-name>
<field-name>

<quoted-name> [[AS] <alias>]
<quoted-name>

"<string>" |
'<string>' |
[<string>] |
<name>
<name>

alpha [ alpha | digit | _ | # ...]
<number>

digit [digit...]
<new-exp>

NEW <field-type> [(<number> [, <number>])]
<field-type>

OLE DB または ADO のデータ型
<string>

unicode-char [unicode-char...]
<expression>

同じ行でオペランドがほかの非 CALC 列の VBA (Visual Basic for Application) 式