Difference between revisions of "EDIT"
Yvonnemilne (Talk | contribs) |
Barrymavin (Talk | contribs) (→Products) |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Full screen editing of records through a form | Full screen editing of records through a form | ||
| Line 43: | Line 36: | ||
==See Also== | ==See Also== | ||
| − | [[APPEND]], [[BROWSE]], [[CHANGE]], [[ | + | [[@...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]] |
| Line 51: | Line 44: | ||
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. | 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 @ | + | 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. | 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. | ||
| Line 196: | Line 189: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| + | [[Category:Screen Forms]] | ||
| + | [[Category:Screen Forms Commands]] | ||
| + | [[Category:UI Commands]] | ||
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.
| Keyword | Description |
|---|---|
| <scope> | If no <scope> is specified, EDIT is activated on the current record and all records are accessible using the [NEXT RECORD] and [PREVIOUS RECORD] keys. |
| FIELDS <field list> | The active fields can be restricted to those specified in the comma separated <field list>. |
| FOR <condition> | Record navigation is restricted to those records that match the <condition>. |
| KEY <exp> | The active records can be restricted to those that match the specified <exp>. The <exp> must be based on the index key of the current master index. |
| NOAPPEND | The ability to append records is disabled. |
| NOCLEAR | Erasing of the screen on entry and exit from EDIT is disabled. |
| NODELETE | The ability to delete records is disabled. |
| NOEDIT | The ability to edit the record is disabled. Access is read only. |
| NOFOLLOW | The NOFOLLOW key word determines whether the record pointer follows a record whose position has changed. A record's position may change when fields that are part of the master index expression are modified. Normally, upon update, the record pointer will be moved to the new position, NOFOLLOW disables this. |
| NOINIT | The work surface retains the keywords and specifications from the last EDIT session. |
| NOMENU | The menu bar is disabled in the default EDIT form. |
| NOORGANIZE | Language compatibility only |
| NOWAIT | Control is returned to the executing program without waiting for the user to exit the EDIT worksurface. |
| WHILE <condition> | Record navigation is restricted to those records that match the specified <condition>. Navigation cannot continue beyond a record that does not match the <condition>. |
The following keys are active in EDIT:
| Key | Action |
|---|---|
| ABANDON | Discard current changes then exit from the form |
| CURSOR DOWN | Skip to next field |
| CURSOR LEFT | Skip to previous field |
| CURSOR RIGHT | Skip to next field |
| CURSOR UP | Skip to previous field |
| DELETE FIELD | Initialize field |
| DELETE RECORD | Delete / Recall the record |
| EDIT FIELD | Enter field edit mode |
| EXIT/SAVE | Write current changes then exit from the form |
| FIND | Find record by key or condition |
| FIND NEXT | Find next record matching specified key or condition |
| HELP | Activate pop-up help |
| MENUBAR | Activate the EDIT menu bar |
| NEXT RECORD | Write current changes then skip to next record |
| PREVIOUS RECORD | Write current changes then skip to next record |
| REFRESH | Redraw the form |
| TAB | Toggle function key menu on and off |
| UPDATE MODE | Toggle update mode on and off |
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:
| Key | Action |
|---|---|
| BACKSPACE | Delete character before cursor |
| CURSOR LEFT | Skip to previous character |
| CURSOR RIGHT | Skip to next character |
| DELETE CHAR | Delete character under cursor |
| DELETE FIELD | Delete from cursor to end of field |
| DELETE WORD | Delete current word |
| INSERT MODE | Toggle insert / overwrite mode |
| WORD LEFT | Skip left a word |
| WORD RIGHT | Skip right a word |
The following menu options are available from the EDIT menu bar in the default form:
| Menu Item | Action |
|---|---|
| Descriptions | Toggle the field descriptions on and off |
| Top | Position to the top of the table or selected records |
| Bottom | Position to the bottom of the table or selected records |
| Order | Select index order |
| Query | Query the table for selected records |
| Help | Activate on-line help system |
Example
use demo edit
Products
Recital
