+---------------------------------+
|             CHANGE              |
+---------------------------------+
CHANGE
        [FIELDS <field list>]
        [<scope>]
        [FOR <expL1>]
        [WHILE <expL2>]
        [FREEZE <field>]
        [KEY <expr1> [, <expr2>]]
        [LAST]
        [LEDIT] [REDIT]
        [LPARTITION]
        [NOAPPEND]
        [NOCLEAR]
        [NODELETE]
        [NOEDIT | NOMODIFY]
        [NOLINK]
        [NOMENU]
        [NOOPTIMIZE]
        [NORMAL]
        [NOWAIT]
        [PARTITION <expN1>]
        [PREFERENCE <expC1>]
        [REST]
        [SAVE]
        [TIMEOUT <expN2>]
        [TITLE <expC2>]
        [VALID [F:] <expL3>
                [ERROR <expC3>]]
        [WHEN <expL4>]
        [WIDTH <expN3>]
        [[WINDOW <window name1>]
        [IN [WINDOW]
        <window name2> | IN SCREEN]]
        [COLOR SCHEME <expN4>
        | COLOR <color pair list>]

-----------------------------------
Changes database records in an editing window.
-----------------------------------

The CHANGE command allows editing of the currently selected database
within a window.  The CHANGE editing window is also available from
within the Browse window.

You can save any changes you make and exit a CHANGE editing window by
pressing Ctrl+W or Ctrl+End, or by clicking on the close box.  If you
press Ctrl+Q or Esc, you can exit the CHANGE editing window without
saving your changes.

The CHANGE command functions identically to the EDIT command.

Clauses
-------

FIELDS
        Displays only fields in <field list>.  <field list> can specify any
combination of database or calculated fields.  Format of <field list>
is:

        <field1> [:R]
                [:V = <expL1> [:F] [:E = <expC1>]]
                [:P = <expC2>]
                [:B = <expr2>, <expr3> [:F]]
                [:H = <expC3>]
                [:W = <expL2>]
                [, <field2> [:R] ...]

Calculated Fields
        Format of statement to create a calculated field:

        <calculated field name> = <expr>

Options for special handling of named CHANGE fields.  These options are
preceded by either : or /.

Option  Handling
----------------
R               Read-only
V               Data validation - not executed for memo fields
F               Force validation, even if field not changed - not executed for memo
fields
E               Error message
P               PICTURE for field
B               Range of numbers
H               Field heading
W               Allows/Prohibits field entry - not executed for memo fields

FOR <expL1>
        Conditionally displays records in Change editing window, filtering out
undesired records.

WHILE <expL2>
        Displays records in Change editing window as long as <expL2> is .T.

FREEZE <field>
        Allows changes to be made to only one <field> in the Change editing
window.

KEY <expr1> [, <expr2>]
        Limits scope of records displayed.  <expr1> is index key value or range
of key values; <expr2> selects records to be displayed.

LAST
        Opens Change editing window in same configuration last saved in FOXUSER
file if RESOURCE is SET ON.  The field list, the size of each field, the
location and size of the CHANGE window and so on are stored in the
FOXUSER file.

        If you issue the CHANGE command with the LAST option, the CHANGE
editing window opens in the same configuration that was last saved in
the FOXUSER file.  This allows you to restore the previous CHANGE
editing window configuration created with the last CHANGE command.  If
the last CHANGE command issued in the Command window had a long list of
options, issuing CHANGE with the LAST option can save you lots of
typing.

        If you exit CHANGE by pressing Ctrl+Q, any CHANGE editing window
configuration changes are not saved.

LEDIT | REDIT
        Left or right partitions are in Browse mode when Change editing window
is displayed.

LPARTITION
        Places cursor in first field in left partition or in right window if
PARTITION not included.

NOAPPEND
        Prevents adding records from in Change editing window.

NOCLEAR
        Leaves image of Change editing window on screen or in window after
window exited.  To clear the image from the screen or window use the
CLEAR command.

NODELETE
        Prevents records from being marked for deletion.  Normally records can
be marked for deletion in a CHANGE window by pressing Ctrl+T, choosing
Toggle Delete from the Browse menu popup, or clicking in the far left
column of the record to be deleted.

NOEDIT | NOMODIFY
        Prevents modifications to database.

NOLINK
        Unlinks partitions.

NOMENU
        Prevents access to Browse menu popup and its options.

NOOPTIMIZE
        Disables Rushmore.

NORMAL
        Opens Change editing window as if there were no windows open or
selected for output.  When a user window is selected for output and is
foremost, the CHANGE window derives its colors, size and position, title
and control options (GROW, FLOAT, ZOOM, etc.) from this window.  If the
NORMAL option is specified, the CHANGE window is opened normally -- it
is opened as if there were no windows open or selected for output.  The
CHANGE window will assume its "normal" attributes.

        The NORMAL clause applies only if there is a user window foremost and