Notes for parameter validation

  • If you are using parameter types 2=AND true/false or 11=OR true/false, use Data Type 3=Long and use Set Indicator 1=MinMax with a range of 0 (false) to 1 (true). Do not use 11=Boolean for Data Type.

    If the Data Type is String or Date, ensure that the Parameter Type is Character Info.

  • If the Data Type is 7=Date, leave the Format Code field blank. The date is stored in the database with the format of the server’s regional settings. What happens when a user with different regional settings requests this data from the server? Optiva translates the date value from the server’s regional settings to the client’s regional settings.
  • Specify a format for numeric parameters in the Format Code field. Use zero (0) to force a zero to display if there is no number for that place, a period (.) for the decimal, and pound (#) to indicate the format of the numbers. For example: 0#.## applied to the number 5.837 results in 05.84. When the Parameter Type is Character Info, ensure that this field is blank.

  • If you are using specifications or formulas, use Set Indicator 1 = MinMax. This validates the min and max values against the Min and Max value for the parameter.

    Set Indicator 0 = Any allows users to enter any valid values.

    Set Indicator 2 = Enum, enables users to select from the drop-list in the Target column. Min and Max values cannot be specified.

  • For an enumerated query, select a query from the FSQUERY table that begins with "ENUM". For example, ENUMSTATUS. Omit the "ENUM" in the Query field in the Parameter form. For example, to use ENUMSTATUS, specify STATUS in the Query field.
  • For an enumerated list, create a custom list or use an existing one.