Foolproof Coding

Table Creation

Field Name Constraint Description
Linked Project ID Read Only The project to which the table belongs
Table Name Alphanumeric, lower case, underscore The name of the table
Servlet Name Alphanumeric, lower case, underscore The name of the servlet serving data from this table
Servlet Alias Alphanumeric, lower case, underscore The servlet alias
Description Alphanumeric, lower case, underscore Freeform description for table
Type Constrained drop list Can be Data, Dual or Maintenance. Maintenance is a table that is a dedicated source for selectable list values. For example, the table tbl_static_lists is defined as Maintenance, as all the drop lists in the Generator App use it as the list source. Dual is a transaction table that serves as the source for a selectable list value. If a list is based on a table and the table is not set to type Dual or Maintenance, the dependent lists are not refreshed when the underlying table data changes.
Sub Type Alphanumeric, lower case, underscore An optional parameter which is usefull for special handling by customisations.
Has Form Constrained list If the table has a user interface. A table can be created without an associated servlet or user interface forms.
Row Seal Active Constrained drop list Generate the forms to provide the row lock feature, which will present a lock icon on a record display or show form. Clicking the lock icon will prevent further edits to the row data, and is permanent. This feature is similar to the Field property "Lock On Edit", except that all the row fields are locked, and the user will determine when the record is to be locked.
Is Audited Constrained drop list If TRUE, a mirror or audit table is generated, where audited field changes are recorded to
Permit Attachments Constrained drop list Permit the user to attach any file to the record.
Has Insert Form Constrained drop list Generate a form for the servlet to present row capture on the table
Permit Row Copy Constrained drop list Provide a COPY icon on the relevant SHOW form for each data row. This will copy all fields into a new row capture form, for editing before commit. The purpose of this feature is to speed up data capture on forms where most fields are the same, and only a few are different between records.
Has Update Form Constrained drop list Generate a form for the servlet to present a row update form based on the underlying data table
Has Search Form Constrained drop list Generate a form for the servlet to present a search form based on the underlying data table
Row Delete Permitted Constrained drop list Permit the user to delete the data row from the underlying table. Do not enable this for any table defined as TYPE=MAINTENANCE or TYPE=DUAL as it will break referrential integrity.
Has Public Access Constrained drop list Has this servlet deployed as Public, with no Tomcat login required to access it
Is Sub Form Constrained drop list Define as a child of a parent table
Search Limit numeric The maximum number of table rows returned to the user interface as a search result.
Parent Name Alphanumeric, lower case, underscore The name of the table of which this table is the child. Setting this parameter defines this table as a child table
Enable Edit on List Constrained drop list Make the search results editable. This is a productivity feature for editing multiple rows, while the data is on one screen.
Created By Read Only User name of row creator
Last Updated By Read Only User name that last modified the row
Creation Date Read Only Timestamp of table row creation
Modified Date Read Only Timestamp of last table row data edit