Difference between revisions of "EDIT"

Latest revision as of 11:22, 30 November 2009

Purpose

Full screen editing of records through a form

Syntax

EDIT

[<scope>]

[FIELDS <field list>

[FOR <condition>]

[KEY <exp>]

[NOAPPEND]

[NOCLEAR]

[NODELETE]

[NOEDIT]

[NOFOLLOW]

[NOINIT]

[NOMENU]

[NOORGANIZE]

[NOWAIT]

[WHILE <condition>]

See Also

@...GET, @...MENU, @...SAY, APPEND, BROWSE, CHANGE, CREATE SCREEN, DEFINE TABLE, FMT(), Function Keys, MODIFY SCREEN, QUERY, READ, SET AUTOSAVE, SET FORMAT, SET FORMSTATE, SET FORMUPDATE, SET KEYWORD, SET LOCKWAIT, SET MENUBAR, SET MOUSE, SET NAVIGATE, SET POSTFORM, SET POSTMENU, SET PREFORM, SET PREMENU, SET QUERYMODE, SET UPDATE, SET VERIFY, SET WINDOW OF MEMO

Description

The EDIT command provides the facility to edit records in the active table that match specified record selection criteria. The EDIT command uses a default form to display and allow updating of the specified records.

When memo fields are displayed, the memo field label is in lower case if the field is empty, and upper case if the field contains text. If a memo window (SET WINDOW OF MEMO) is active, the memo can be displayed and edited in the specified window. Otherwise, pressing the [INSERT] key or the [HELP] key on the memo field will popup a notepad editor. Pressing the [HELP] key within the notepad editor displays the memo editing keys available. These keys include facilities for reading from and writing to external files and printing on the system printer.

You can design your own forms using the Forms Designer (CREATE SCREEN). The Form Designer will automatically generate a format file that can contain @...GET, @...SAY, @...MENU and other display objects. This form will be used by the EDIT command if it has been activated using the SET FORMAT command.

If the active table is shared, then automatic record locking will take place for each of the tables referenced on the form. The records are automatically unlocked when you skip to another record, or exit from the EDIT command. If UPDATE is ON then 'Upd' appears in the 3rd box of the status bar at the bottom of the screen. When UPDATE is ON records are automatically locked before they are read from the database. When UPDATE is OFF, no record locking is performed. It is recommended that you toggle UPDATE mode ON when you have a record displayed on the form which you want to update, and leave UPDATE OFF while you are browsing through your records. If SET LOCKWAIT is OFF, then whenever an attempt is made to lock a record that is already locked by another user, you are given the choice of waiting for the lock or continuing in query mode.

When UPDATE is toggled ON, the form is refreshed with the most current information from the table. As only one user at a time can be in UPDATE mode on a particular record, the information displayed on the form is always current at the time of editing. The changed data on the form is written to the table and the lock released when the [EXIT/SAVE], [NEXT SCREEN], [PREVIOUS SCREEN] or [MENUBAR] keys are pressed. If the [ABANDON] key is pressed and changes have been made to the data, SET VERIFY ON causes a dialog box to be displayed asking for confirmation.

The following keys are active in EDIT:

If SET MOUSE is ON, cursor keys will move the cursor anywhere on the screen rather than just from field to field. If SET NAVIGATE is ON, the cursor moves to fields following the direction specified by the key being pressed, rather than following the order of the GETS on the form. When the RETURN key is pressed, the cursor moves to the nearest field when SET NAVIGATE is ON.

The following keys are active in field edit mode:

The following menu options are available from the EDIT menu bar in the default form:

Example

use demo
edit

Products

Recital