以下是创建 Shape 命令的规范语法。
? | 必需的语法项为尖括号 (“<>”) 界定的文本字符串。 |
? | 可选项由方括号 (“[ ]”) 界定。 |
? | 任选其一项用竖线 (“|”) 隔开。 |
? | 重复的可选项用省略号 (“...”) 表示。 |
? | Alpha 表示字母字符串。 |
? | Digit 表示数字字符串。 |
? | Unicode-digit 表示由 unicode 数字组成的字符串。 |
所有其他项目均为文字。
项目 |
定义 |
<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> [[AS] <alias>]] |
<aliased-field-list> |
<aliased-field> [, <aliased-field...] |
<aliased-field> |
<field-exp> [[AS] <alias>] |
<field-exp> |
(<relation-exp>) |<calculated-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>] |
<calculated-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>) | CALC(<expresion>) |
<qualified-field-name> |
<alias>.[<alias>...]<field-name> |
<alias> |
<quoted-name> |
<field-name> |
<quoted-name> |
<quoted-name> |
"<string>" | '<string>' | [<string>] | <name> |
<name> |
alpha [ alpha | digit | _ | # ...] |
<number> |
digit [digit...] |
<string> |
unicode-char [unicode-char...] |
<expression> |
Visual Basic for Applications 表达式,其操作数是相同行中其他非 CALC 列。 |