Share via

Expression Recordset Example (PIA)

  • Article

[Visual Basic .NET]

The following examples show two Recordset objects containing expressions. The first is for an expression (ID = 7) dependent on one profile (User) and no expressions. The second is for an expression (ID = 24) dependent on one other expression (ID=7) and two hypothetical profiles (Product and User). The DateCreated, DateModified, rsExprDeps, and rsProfDeps fields are not shown.

Parent Recordset for Expression7

ExprID ExprName Category ExprDesc ExprBody
7 “Expression7” “Hair” “Brown” String7

Expression Dependencies Child Recordset for Expression7

ExprID ExprDep
- -

Profile Dependencies Child Recordset for Expression7

ExprID ProfDep
7 “User” 
String7 = "<CLAUSE OPER="is-true">
             <PROPERTY ID="User.GeneralInfo.hair" TYPE="string"/>
             <IMMED-VAL TYPE="string">Brown</IMMED-VAL>
           </CLAUSE>"

Parent Recordset for Expression24

ExprID ExprName Category ExprDesc ExprBody
24 “Expression24” “Octogenarians” brown_haired_users_over_80 String24

Expression Dependencies Child Recordset for Expression24

ExprID ExprDep
24 7

Profile Dependencies Child Recordset for Expression24

ExprID ProfDep
24 “Product”
24 “User” 
String24 = "<TERM TYPE="and">
              <CLAUSE OPER="is-true">
                <EXPR-REF ID=7/>
              </CLAUSE>
              <CLAUSE OPER="equal">
                <PROPERTY ID="Product.name" TYPE="string"/>
                <IMMED-VAL TYPE="string">hair dye</IMMED-VAL>
              </CLAUSE>
              <CLAUSE OPER="at-least">
                <PROPERTY ID="User.GeneralInfo.age" TYPE="number"/>
                <IMMED-VAL TYPE="number">80</IMMED-VAL>
              </CLAUSE>
            </TERM>"

[C#]

The following examples shows two Recordset objects containing expressions. The first is for an expression (ID = 7) dependent on one profile (User) and no expressions. The second is for an expression (ID = 24) dependent on one other expression (ID=7) and two hypothetical profiles (Product and User). The DateCreated, DateModified, rsExprDeps, and rsProfDeps fields are not shown.

Parent Recordset for Expression7

ExprID ExprName Category ExprDesc ExprBody
7 Expression7 Hair Brown String7

Expression Dependencies Child Recordset for Expression7

ExprID ExprDep
- -

Profile Dependencies Child Recordset for Expression7

ExprID ProfDep
7 User 
String7 = "<CLAUSE OPER="is-true">
             <PROPERTY ID="User.GeneralInfo.hair" TYPE="string"/>
             <IMMED-VAL TYPE="string">Brown</IMMED-VAL>
           </CLAUSE>"

Parent Recordset for Expression24

ExprID ExprName Category ExprDesc ExprBody
24 Expression24 Octogenarians Brown_haired_users_over_80 String24

Expression Dependencies Child Recordset for Expression24

ExprID ExprDep
24 7

Profile Dependencies Child Recordset for Expression24

ExprID ProfDep
24 Product
24 User 
String24 = "<TERM TYPE="and">
              <CLAUSE OPER="is-true">
                <EXPR-REF ID=7/>
              </CLAUSE>
              <CLAUSE OPER="equal">
                <PROPERTY ID="Product.name" TYPE="string"/>
                <IMMED-VAL TYPE="string">hair dye</IMMED-VAL>
              </CLAUSE>
              <CLAUSE OPER="at-least">
                <PROPERTY ID="User.GeneralInfo.age" TYPE="number"/>
                <IMMED-VAL TYPE="number">80</IMMED-VAL>
              </CLAUSE>
            </TERM>"

Copyright © 2005 Microsoft Corporation.
All rights reserved.