Parameter nameUse this tab to provide additional information about the parameters you have included in the SQL statement on the SQL tab. The table on the left-hand side shows any parameters entered in the SQL statement on the SQL tab.
The parameter name is created automatically and cannot be changed.
This field shows the type of the parameter value, such as Integer, String, or Date.
Note: The parameter type cannot be determined automatically. You have to enter the type yourself.
This is the default value of the parameter. This value is used if the user applying the preset does not manually specify a value for the parameter. Enter 'NULL' to set the default value to NULL.
To specify a default value for the parameter, you can use the Default value field, or you could specify a script. This script would enable Isah to determine a default value, for example in the dialog box where the user is prompted for a parameter value.
The script must include a GetDefaultValue() function. The return value of this function is used as the default value. Examples are 'Today's date' and 'Logged in user'.
It is possible to have a user enter a parameter value on the basis of which the preset will be applied. In the Prompt field, enter the question to be displayed when the user is about to apply the preset. This question will be displayed in a dialog box.
Use this check box to specify whether the parent data set (if any) is to be searched for the parameter value. This check box controls the Bound property of the parameter.
Example
Parameters can be made dependent on the value found in the parent record. An 'operation', for instance, may have a 'production file' as its parent (the operation is part of a production file).
Select the Find in parent check box. If you select 'Never' in the If in parent field, all operations will be displayed, independent of the production file. If you select 'Always', the user is asked to specify the production file when he opens the preset. If you re-select the preset on the preset form, this question will be asked again. If you select 'Once', this question will be asked only once, when the form is opened.
Use this list box to specify whether the user is allowed to change the parameter value if it is found in a parent data set:
|
The value can be refreshed each time the user activates the preset. |
|
The user can change the value only the first time. |
|
The user cannot change the value. |
Example
Parameters can be made dependent on the value found in the parent record. An 'operation', for instance, may have a 'production file' as its parent (the operation is part of a production file).
Select the Find in parent check box. If you select 'Never' in the If in parent field, all operations will be displayed, independent of the production file. If you select 'Always', the user is asked to specify the production file when he opens the preset. If you re-select the preset on the preset form, this question will be asked again. If you select 'Once', this question will be asked only once, when the form is opened.
Use this list box to specify whether the user is allowed to change the parameter value if it is not found in a parent data set:
|
The value can be refreshed each time the user activates the preset. |
|
The user can change the value only the first time. |
|
The user cannot change the value. |