形状语法格式

目录

以下是创建 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> [[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 列。

www.51windows.Net