Manipulating Records

In an Info Box, to move the cursor to the next record, click the icon or choose Record, Next from the menu. The keyboard shortcut for this option is DOWN ARROW.

In an Info Box, to move the cursor to the previous record, click the icon or choose Record, Previous from the menu. The keyboard shortcut for this option is UP ARROW.

In a multi-record Info Box, to move the cursor to the next page of records, click the icon or choose Record, Next Page from the menu. The keyboard shortcut for this option is PAGE DOWN.

In a single-record Info Box, this option moves the cursor to the next record.

In a multi-record Info Box, to move the cursor to the previous page of records, click the icon or choose Record, Previous Page from the menu. The keyboard shortcut for this option is PAGE UP.

In a single-record Info Box, this option moves the cursor to the previous record.

In an Info box, to insert a new (empty) record at the current cursor position, click the icon or choose Record, New from the menu. There is no need to use this option if the cursor is already in an empty record. The shortcut key for this action is ALT+INSERT.

In an Info Box, to copy the values of the previous record into the current record, click the icon, or choose Record, Duplicate from the menu. After duplicating a record in this way, change the values that are particular to the duplicated record. Of necessity, you must change at least the value(s) of unique key fields because these must be unique across records - unless key values are generated, in which case USoft Developer will generate a unique value automatically them. The shortcut key for this action is F7.

To duplicate a field, choose Record, Duplicate Field from the menu bar. This copies the field value of the previous record into the same field of the current record. If the field you duplicate is (part of) the key, you must change its value - unless it is automatically generated, in which case USoft Developer will change it. The shortcut key for this action is ALT + R,L.

To clear a field, position the cursor in the field and choose Record, Clear Field from the menu bar. This removes the current field value. The field value is not physically removed from the database, however, until you save your changes.

A window may contain one or more info boxes. Clearing an info box means that the data is removed from the screen, not from the database. The values are not removed from the database until you save your changes.

To clear an info box, position the cursor in any field in the box, and choose Box, Clear from the menu bar or press ALT+F5.

If the info box is the highest parent displayed in the window, then all info boxes will be cleared. If the info box is a child, only that info box and any lower info boxes will be cleared.

In an Info Box, to remove the current record, click the icon or choose Record, Delete from the menu. The record is not physically removed from the database, however, until you save your changes. The shortcut key for this action is CTRL+D.

To undo your last action, click the icon or choose Record, Undo from the menu. The shortcut key for this action is CTRL+Z.

Last actions you may undo include a New (record) command, a Duplicate command, but also any text edits you have made before storing the row. You CANNOT undo actions that you have already committed.

To save your work locally, choose Record, Store Row from the menu bar. This saves your changes in a (local) memory buffer, allowing you to continue without physically committing your changes to the database. You will probably need to do this quite often, in order to make data from one table available to another window.

NOTE: Each time that you leave a window in which you have made a change, a local save is automatically made by the Definer.

To actually commit your changes, you must click the Save button on the toolbar or choose File, Save from the menu bar.