value [Parameter]

Topic group Related topics Example

The input, output, or result value of a stored procedure.

Property of

Parameter

Description

Values are transmitted to and from stored procedures through Parameter objects. Each object’s type property indicates what type of parameter the object represents. Depending on which one of the four types the parameter is, its value property is handled differently.

Input: an input value for the stored procedure. The value must be set before the stored procedure is called.

Output: an output value from the stored procedure. The value must be set to the correct data type before the stored procedure is called; any dummy value may be used. Calling the stored procedure sets the value property to the output value.

InputOutput: both input and output. The value must be set before the stored procedure is called. Calling the stored procedure updates the value property with the output value.

Result: the result value of the stored procedure. In this case, the stored procedure acts like a function, returning a single result value, instead of updating parameters that are passed to it. Otherwise, the value is treated like an output value. The name of the Result parameter is always "Result".

If a Parameter object is assigned as the dataLink of a component in a form, changes to the component are reflected in the value property of the Parameter object, and updates to the value property of the Parameter object are displayed in the component.