干预形状计算子句
适用于:Access 2013、Office 2013
在参数化 Shape 命令中,在父和子之间嵌入一个或多个 COMPUTE 子句将是有效的,如下例所示:
SHAPE {select au_lname, state from authors} APPEND
((SHAPE
(SHAPE
{select * from authors where state = ?} rs
COMPUTE rs, ANY(rs.state) state, ANY(rs.au_lname) au_lname
BY au_id) rs2
COMPUTE rs2, ANY(rs2.state) BY au_lname)
RELATE state TO PARAMETER 0)