Record Edit Screen

The Record Editor looks like

This screen consists of three parts


Section Description
Top Left This is the Record Selection This is where you enter selection options to limit what is displayed in the Record List. To display all records starting with t; enter t% in the Record Name field.


Bottom Left This is the Record List panel You can select a record to be displayed by clicking on it

Right On the right part of the screen is Record Definition.

The fields on this section of the screen are:

Field

Description

Buttons

The buttons at the top of Record Screen Save, Create, Repeat, Delete and reload Record Details to/from the Database.

Record Name & Description

Self Evident

Record Type

There are 3 basic Record Types (+ binary versions of these):

Record Layout

A normal record consisting of a one or more fixed length fields.

Delimited

Standard Delimiter (i.e. Comma or Tab Delimited) Record. Delimiter files are only partially supported (no updates allowed).

Group of Records

The record consists of a Group of other records. Typically there is a field that determines what record to use. It is common for a file to contain

  • A File Header Record
  • Many Detail Records
  • A file trailer record

This would be a good candidate for using a Group of Records. In this case you would define 4 records:

  • File Header Record
  • Detail Record
  • Trailer Record
  • Master Record (Group of Records) that references the three previous (child) records.

See "Child Records" for the Child Record Definition screen section.

System

System this Record Layout belongs to. You can Change Create new systems by updating the System Table via the "Table Edit"

Lines to Insert

This is the lines to insert in the Field Table / Sub-Record Table when the insert button (just below) is pressed.

Table Buttons

The second row of buttons refer to the Field Table / Sub-Record Table immediately below the buttons

Record Details

Lastly we have a Tab Box holding the "Field Records"/"Child Records" tables + the "Extra Panel". These panels define record details.

Note: The "Child Records" panel is displayed when Record Type=Group of Records or Group of Binary records Records otherwise "Field Records" is displayed.

Note: See "Record Layout Definition" for more details.