Intervening Shape COMPUTE Clauses

Microsoft ActiveX Data Objects (ADO)

ADO 2.5

Intervening Shape COMPUTE Clauses

It is valid to embed one or more COMPUTE clauses between the parent and child in a parameterized shape command, as in the following example:

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)

See Also

Data Shaping | Formal Shape Grammar | Shape Commands in General

© 1998-2003 Microsoft Corporation. All rights reserved.