Parameters

This field is used with the Call Database Method, Call IDO Method, and Dispatch IDO Method action types.

Use this field to specify a comma-separated list of parameters required by the IDO method or stored procedure.

To define parameters using the Event Action Call Database Method form or the Event Action Call IDO Method form, click the button to the left of this field.

Each parameter listed in this field must use one of these syntax statements:

scalarExpr

RV( var )

RE( param )

where:

  • scalarExpr is or resolves to an expression that can be used as a parameter or variable by the IDO method or stored procedure.

    These are all examples of scalar expressions valid for this parameter:

    • "Parm1": literal string value
    • 123: numeric value
    • E(MyEventParm): expression
    • POWER(2,3): function
  • var is the name of a variable in which a return value (RV) is to be stored.
  • param is the value of a parameter being returned (RE) by the IDO method or stored procedure.

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

PARMS( scalarExpr | RV( var ) | RE( param ) [, ... ] )

Note: 
  • If scalarExpr is a literal string value, the system automatically encloses it in double quotation marks when returning it to the Event Actions form. If scalarExpr is anything else, the system does not enclose it in quotation marks.
  • If a variable is named using this function and that variable does not already exist for the current handler, the system creates it automatically as a non-persistent variable.
  • If a parameter is set using this function, and that parameter was not passed into the current event, the system creates it automatically as an output parameter.