F6 - Workarea Screen Show information about the workareas in use. ──────────────────────────────────────────────────────────────────────────────
There are five sections to this screen. You may move to and from sections of this screen by using the <TAB> or <Shift><TAB> keys. As you change from section to section, the border of each section will change. A border with a double line represents the section that you are currently in.
You cannot move into the top right hand section, locks, when there are no record locks. When there are record locks, you may only cursor ↑ or ↓ through the list of record locks.
You may not <TAB> into the section entitled Status, as this is purely for display purposes, although some actions allow you to enter information into this section such as <Alt><G>, which is the Goto Record command.
<Alt><G> will allow you to enter a record number in the Status section and a GOTO will be performed for that record number in the currently highlighted workarea.
<Alt><F> will allow you to enter a filter expression for the current workarea. After you enter a filter expression, as GO TOP is performed which activates the filter.
<Alt><R> will allow you to select a child workarea and expression, into which you can form a relation. <Alt><R> produces a list of workareas that are currently open with the current index expression. You may use the ↑ or ↓ keys to select the child workarea and expression.
The first time that a relation is added to a workarea, you can edit the expression in the Status section. Subsequent additions to this will bring up a different box to edit the expression in.
Please Note: Make sure that the index expression in the child work area is adequate to support the relation. If it is not, and there is another index that will fit your needs, then you will need to change the index. The quickest way of doing this is, is to change to the index section, using the <TAB> or <Shift><Tab> keys, use the ↑ or ↓ down key to move to the index that you want, pressing ◄──┛ and the <Esc>. This changes the index order for you.
Within the alias window, the ↑ and ↓ keys will allow you to change the workarea that the other sections are displaying data from. By typing the first letter of an alias, you can change to that workarea. Repetitive key presses of the same letter will cycle through the aliases beginning with the letter.
The current workarea, from the application's point of view, will be displayed using it's own set of colours.
The upper section in the middle of the screen shows you relevant information about the current alias including such wonderful items as the record number, the number of records within the file, the status of BOF(), EOF(), NETERR(), the RDD for the work area, the record size, the header size, the number of fields, the filter expression, if any, the relation expression(s), if any, the deleted status for the current record and the workarea number.
The centre of the screen shows the record structure and the contents of the current record. You can use the <+> or <-> keys at any point to skip forward or backward a record at a time. <Ctrl><+> or <Ctrl><-> take you to the first or last record in the file, respectively.
To edit a record, you will first need to move to the Structure section. Once inside the Structure section you may use the ↑ or ↓ keys to move to the record that you wish to edit and then press ◄──┛.
At anytime you can change the view of the workarea by using <Alt><V>. This toggles the display mode of the workarea from structure mode to view mode and from view mode to structure mode. View mode displays the contents of the workarea in a browse mode. You can then scroll to your hearts contents. This mode is best used when using large amounts of screen space i.e. 132x50 etc.
You may then use either ↑, ↓, → or ← to move around the view. At any point you can press ◄──┛ and edit the field. Any changes made to the data held within the fields is permanent, there is no undo facility.
The Index section allow you to see the index or indices currently open. You may use ↑ or ↓ to browse through the list of indices. To change the current index, the quickest way to do this is by moving the highlight bar to the index of your choice, pressing ◄──┛ followed by <Esc>. This performs a DBSETORDER() on the specified index.
You can also perform a SEEK on an index by pressing ◄──┛ on an index and typing in an expression. If the index that you choose is not the current index, then the index order will be changed to the index that you pressed ◄──┛ on.
You may perform a SEEK, on the current index, at any time by pressing <Alt><S>. This will allow you to enter an index expression to seek on, using the current index.
When you come to leave this screen, a simple <Esc> will close this workarea screen down and restore all of the original settings as they were, when you first came into this screen. Should you wish to save any of the changes that you have made, such as a move to a record pointer within a workarea, or a different index order, then <Ctrl>◄──┛ will make these changes permanent.