BROWSE

BROWSE (Short name: BRO)

Use the BROWSE command to display data.

DISTINCT
Suppresses the display of duplicate rows.

*
Specifies all columns.

,
Indicates that this part of the command is repeatable.

corr_name.
Correlation name. A nickname or alias for a table or view name. Use corr_name to refer to the same table twice within the command, or to explicitly specify a column in more than one table.

tblname.
Specifies a column using the table name. Use tblname.* to specify all columns in the table.

colname
Specifies a 1 to 18 character column name. In a command, you can enter #c, where #c is the column number shown when the columns are listed with the LIST TABLES command. In an SQL command, a column name can be preceded by a table or correlation name and a period (tblname.colname). You can enter tblname.* to specify all columns in the table.

(expression)
Determines a value using a text or arithmetic formula. The expression can include other columns from the table, constant values, functions, or system variables such as #date, #time, and #pi.

=READ
Specifies that the column is read-only, preventing changes to data.

FROM tblview
Specifies the table or view.

WHERE clause
Limits rows of data. For more information, see the "WHERE" entry.

ORDER BY clause
Sorts rows of data. For more information, see the "ORDER BY" entry.

NOCHG
Prevents changes to the issued BROWSE command; stops users from reaching additional data by adding columns to the command or changing the command's WHERE clause. When the NOCHG option appears in the command, users cannot toggle from BROWSE to EDIT by pressing [F4], nor by using the Editmenu in R:BASE for Windows. NOCHG is particularly useful when the BROWSE command is issued within an application or command file.

MDI
This option is used in R:BASE for Windows only; specifies a modeless window-a modeless window allows you to access other windows without closing the current window first.

OPTION parameters - provides the ability customize the Data Browser Window. These enhanced parameters are supported at the R> Prompt, in command files, EEPs and Stored Procedures.

WINDOW_STATE value

To setup Data Browser window state with the following supported values:

MAXIMIZED - show maximized

NORMAL - show normalized

MINIMIZED - show minimized

CAPTION value

To change Data Browser window caption.

LOCK nnn

To lock a number of columns in Data Browser window.

ROWVIEW

To open Data Browser window in "View as Row" mode.

READONLY value

To open Data Browser window in Read-Only mode. (Default is OFF)

OFF

MODAL value

To open Data Browser as modal/non-modal window. (Default is ON)

OFF

EXPORTRESULT value

To enable/disable the "Export Result to->" menu item. (Default is ON)

OFF

SAVERESULT value

To enable/disable the "Save Data As->" menu item. (Default is ON)

OFF

PRINTDATA value

To enable/disable the "Print Data" menu item. (Default is ON)

OFF

About the BROWSE Command

The BROWSE command starts the Data Browser and displays the information you specify.

Examples

Example 01:

The following command displays all columns in the transmastertable and sorts the rows by the customer identification numbers contained in custid column.

BROWSE * FROM transmaster ORDER BY custid

Example 02:

The following command displays the custid, company, custaddress, custcity, custstate, and custzip columns in the customer table. Only the rows where the customer identification is equal to 100 are displayed.

BROWSE custid, company, custaddress, custcity, custstate, custzip FROM customer WHERE custid = 100

Example 03:

The following command displays the custid column and restricts editing. Do not place a delimiter, such as a comma or a space, between options prefaced with an equal sign when you are building a command.

BROWSE custid=read, company, custaddress, custcity, custstate, custzip FROM customer WHERE custid = 100

Example 04:

The following command open all records for the Customer table with a maximized Data Browser window and "Customer Data" as the caption.

BROWSE ALL FROM customer OPTION WINDOW_STATE MAXIMIZED|CAPTION Customer Data

Example 05:

The following will start the Data Browser for custid 125, displaying the data as a single row in read only mode.

BROWSE ALL FROM customer WHERE custid = 125 OPTION WINDOW_STATE NORMAL|ROWVIEW|READONLY ON