Parameters
This field is used with the Call Database Method, Call IDO Method, and Dispatch IDO Method event action types 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 Event Actions form, the application "wraps" this content within a PARMS( ) parameter, which yields this final syntax:
to return to thePARMS( scalarExpr | RV( var ) | RE( param ) [,
... ] )
- If scalarExpr is a literal string value, the application automatically encloses it in double quotation marks when returning it to the Event Actions form. If scalarExpr is anything else, the application 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 application 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 application creates it automatically as an output parameter.