- Editing Rows and Basic Settings

Editing Rows Within the Field Descriptor Manager

To change the settings on an individual row that is shown under the Field Descriptor section, click the

edit icon next to the Field Descriptor you wish to edit. This will bring up a screen containing the

Field Descriptor settings that can be edited. The screen shot below covers the first two sections:

Basic Settings and Display Settings.

Basic Settings

• • Field Name - The database name of the column which this Field Descriptor describes. In the above example, the Field Descriptor for the SERVICE_COMPANY column is being edited.

  • External Name - The external name given to the field. External names are used to make the field name more user-friendly.

  • Required - Indicates whether or not the described field is required. Required fields are denoted by a red asterisk, and are validated when a row is updated or inserted. If a required field is left blank on an insert or update, a validation error is displayed to the user.

  • Required on Search - Indicates that if the field is used by a search parameter (ex. WHERE FLD1 = ?), a value must be specified before the search operation is performed.

  • Default Value - The default value for the field. A default value can be any value you want initially displayed. If the field is auto-incremented, the default value can be used to set the starting value.

  • Global Values - To make a field global, go to the Usage Id property and set this to Global Value (-3). Once you update the field, it will then display that field under the Default Value to be chosen.

    • 
      

  • Session (*Last) -Allows a user to have default values set for specified fields for the duration of a session only.

Auto Update Value - [EE] This value will set for the field when an update is performed. The same rules apply to this setting as the Default Value setting. A common use for this option would be for a field that is designated to contain the "last changed" date, time, or time-stamp value. In this particular example, you would set this option’s value to *current. Any time this row is successfully updated, the last changed value would be updated as well.

[WOW 7.1] WOW only includes fields whose values have changed when generating an SQL UPDATE. In some cases such as workflow applications, you may want a field to be updated into the database regardless if it changed. For example:

SELECT ‘APPROVED” as status, B, C FROM LIB.REQUESTS

… When updating, you may want STATUS included when the row is updated. Supports a special value of *VALUE to indicate that this field should be included when an edit/update is performed.