[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
        Conditionally displays records in a Browse window, filtering out
undesired records.  For best performance, use an optimizable expression
in the FOR clause.

FORMAT
        Displays data with a format file.  The following information is
extracted from the format file and applied to the Browse window:

        . the list of fields to BROWSE

        . any specified VALID clauses

        . any specified WHEN clauses

        . any specified RANGE clauses

        . fields are sized as specified in PICTURE clauses

        . all SAY expressions are included as calculated BROWSE fields

FREEZE <field>
        Allows changes to be made to only one <field> in the Browse window.
All fields are still displayed unless a FIELDS list is included.

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 BROWSE 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 Browse window and so on are stored in the
FOXUSER file.

        If the last Browse window was opened with a PREFERENCE name, BROWSE
LAST will not restore the preference.

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

LOCK <expN1>
        Specifies number of fields to be placed in their own partition in
Browse window.

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

NOAPPEND
        Prevents adding records from within a Browse window.

NOCLEAR
        Leaves image of Browse window on screen or in window after Browse
exited.

NODELETE
        Prevents records from being marked for deletion.  Normally records can
be marked for deletion in a Browse 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.

NOLGRID | NORGRID
        Removes vertical field grid lines in the left and right partitions.

NOLINK
        Unlinks partitions.

NOMENU
        Prevents access to Browse menu popup and its options.

NOOPTIMIZE
        Disables Rushmore.

NOREFRESH
        Prevents Browse window from being updated.  Browse windows are
refreshed at the rate determined by SET REFRESH.  NOREFRESH is useful
with read-only files, and improves performance.

NORMAL
        When a user window is selected for output and is foremost, the Browse
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 Browse window is opened normally - it is opened as if
there were no windows open or selected for output.  The Browse window
will assume its "normal" attributes.

        The NORMAL clause applies only if there is a user window foremost and
selected for output.

NOWAIT
        Continues program execution after Browse window has been opened.

PARTITION <expN2>
        Splits Browse window.  <expN2> specifies column where window splitter
is located.

PREFERENCE <expC1>
        Saves Browse window's attributes and options in the resource file for
later use.  When a user window is selected for output and is foremost,
the Browse window derives its colors, size and position, title and
control options (GROW, FLOAT, ZOOM, etc.) from this window.

REST
        Used with BROWSE FOR to prevent Browse window from repositioning record
pointer at top of database file.

SAVE
        Keeps Browse window and any open memo windows on screen after Browse
window has been exited.

TIMEOUT <expN3>
        Specifies how long Browse window waits for input.   <expN3> specifies
how many seconds can elapse without any input before Browse window is
automatically closed.

TITLE <expC2>
        Specifies the title <expC2> that appears in top border of Browse
window.

VALID <expL2> [ERROR <expC3>]
        Evaluated when a record is chosen.  Typically, <expL2> is a UDF.

        Including the VALID clause lets you perform row (record) level
validation in a Browse window.  The VALID clause is executed only if a
change is made to the record and you move to another record.  The VALID
clause is NOT executed for memo fields.

        If the VALID clause returns a logical true value (.T.), you can move to
another record.

        If the VALID clause returns false, the cursor remains in the current
field in the current record and the system message "Invalid Input" is
displayed.  You can display your own error message when the VALID clause
returns false by including the ERROR <expC3> clause.  The character
expression <expC3> is displayed in a system window.

        If the VALID clause returns 0, the cursor remains in the current field
of the current record, and no error message is displayed.

        You can force the VALID clause to be executed before you move to the
next record by including :F or /F after the VALID keyword.  In this case
the VALID clause is executed even if the record is not changed.

WHEN <expL3>
        Allows or prohibits selection of a record.  Often, <expL3> is a UDF.
If the WHEN clause returns false or 0, the record you move to is made
read-only.  The WHEN clause is NOT executed for memo fields.

WIDTH <expN4>
        Limits number of characters displayed for all fields.  The WIDTH option
does not change the size of fields in the database itself, only the way
the fields are displayed in the Browse window.  If a width has been
specified for an individual field within the FIELDS option, it overrides
the WIDTH clause for that particular field.

WINDOW  <window name>
IN WINDOW <window name2>
        Open Browse window in another window.  The window the Browse window is
to be placed in must first be defined with the DEFINE WINDOW command.
The WINDOW option ACTIVATEs the window and places the Browse window in
it.  The Browse window will fill the entire window and take on the
characteristics of the window it is placed in.  For example, if the

This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson