Dictionary Index  PREV  NEXT
dictionary_banner (2K)

dict_table(upd1) - Update Table

dict_table(upd1) (19K)

The purpose of this function is to allow the user to update the details of entries on the DICT_TABLE table of the data dictionary.

This form is accessed by an option on the navigation bar in the List Table screen.

For a complete description of how this type of form works please see Transaction Pattern UPDATE 1.

Field List
Field NameTypeDescription
Database ID STRING Required. Primary Key, as loaded by the IMPORT DATABASE function.
Table ID STRING Required. Primary Key, as loaded by the IMPORT TABLE function.
Name STRING Required. The name for this entry.
Description TEXT Optional. A description for this entry.
Audit Logging? STRING Optional. This indicates if changes to this table will be recorded in the Audit Logging database. Possible values are:
  • No - no changes will be logged.
  • ENABLED - all changes will be logged
Default Sort Seq STRING Optional. When occurrences of this table are retrieved for LIST screens this will be used as the sort sequence (unless other sorting criteria has been specified either for the TASK or by the use of the column headings).
Alternative Language Table STRING Optional. The identity of the table which provides text in alternative languages for this table. If non-empty the following rules must be satisfied:
  • The alternative table must reside in the same database (schema) as the main table.
  • The primary key of the alternative table must include all the columns which comprise the primary key of the main table.
  • The primary key of the alternative table must have language_id as its last element so that it can be linked to the LANGUAGE table in the MENU database.
  • The field list for the alternative table must include at least one text field which exists on the main table. (see Alternative Language Columns)
Alternative Language Columns STRING Display only. The list of columns on the alternative table which provide text in different languages.
Alias for START_DATE STRING This is where a column designates the record's start date, but has a different name.
Alias for END_DATE STRING This is where a column designates the record's end date, but has a different name.
Extra Names Database STRING This is the ID of the database which contains the Extra Names Table, if different from the current database.
Extra Names Table STRING This is the ID of the table which stores the names of any User Defined Fields.
Extra Values Database STRING This is the ID of the database which contains the Extra Values Table, if different from the current database.
Extra Values Table STRING This is the ID of the table which stores the values for any User Defined Fields.
The following fields are set automatically by the system:
created_date DATE+TIME The date and time on which this record was created.
created_user STRING The identity of the USER who created this record.
revised_date DATE+TIME The date and time on which this record was last changed.
revised_user STRING The identity of the USER who last changed this record.
copyright (1K)
http://www.tonymarston.net
http://www.radicore.org