Result Set Assignment

Use this field to specify a name (ID) of your choosing that will be used by a later expression to identify the result set, that is, the set of rows retrieved.

The expression that later uses this result set must include:

  • For an Update Collection action only: COLLECTION( ID )
  • For other actions:
    • ROWS( ID )
    • PROPERTY( ID, row#, propName )
    • FILTERPROPERTY( ID, row#, propName )

To use the Event Action Set Result Set ID form as an aid in constructing the proper syntax for this parameter, click the button to the left of this field.

The contents of this field must use this syntax:

R( ID ) = RESULT

where ID is a non-quoted literal identifier to be assigned to the result set.

When you click OK to return to the Event Actions form, the system "wraps" this content within a SET( ) parameter, which yields this final syntax:

SET( R( ID ) = RESULT )