The purpose of this form is to allow the user to browse through the contents of the DICT_TABLE table of the dictionary database for a selected DICT_DATABASE entry.
This form is accessed by an option on the navigation bar in the List Database screen.
For a complete description of how this type of form works please see Transaction Pattern LIST 2.
Button | Action |
---|---|
Search | Will refine the selection criteria for this screen by activating Search Table |
Import Tables | Will import table names into the dictionary database by activating Import Table |
Child Relationships (DB) | This will show Child Relationships for the current database by activating List Child Relationships by Database |
Parent Relationships (DB) | This will show Parent Relationships for the current database by activating List Parent Relationships by Database |
Read | Will view the details of selected entries by activating Enquire Table |
Update | Will update selected entries by activating Update Table |
Delete | Will delete selected entries by activating Delete Table |
Export to PHP | Will export dictionary details for the selected table(s) by activating Export to PHP |
Columns | This will show Columns for selected Tables by activating List Columns by Table |
Keys | This will show Keys for selected Tables by activating List Keys by Table |
Child Relationships (Table) | This will show Child Relationships for selected Tables by activating List Child Relationships by Table |
Parent Relationships (Table) | This will show Parent Relationships for selected Tables by activating List Parent Relationships by Table |
Audit Trail | Will show the audit trail (LIKE) for selected entries as described in Appendix L. |
Audit Trail (2) | Will show the audit trail (exact match) for selected entries as described in Appendix L. |