EDIT

EDIT (Short Name: EDI)

Use the EDIT command to change data.

Options

DISTINCT
Suppresses the display of duplicate rows. If you specify DISTINCT, you cannot change the data that is displayed.

*
Specifies all columns.

,
Indicates that this part of the command is repeatable.

colname
Specifies a 1 to 18 character column name.

<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 tbleview
Specifies the table.

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.

MDI
Specifies a modeless edit window-a modeless edit window allows you to access other windows without closing the edit window first.

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

WINDOW_STATE value

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

MAXIMIZED - show maximized

NORMAL - show normalized

MINIMIZED - show minimized

CAPTION value

To change Data Editor window caption.

LOCK nnn

To lock a number of columns in Data Editor window.

ROWVIEW

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

READONLY value

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

OFF

MODAL value

To open Data Editor 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 EDIT Command

The EDIT command starts the Data Editor and displays the data you specify. In a multi-user environment, R:BASE checks whether the row of data you are editing has been changed by another user and notifies you if it has - this is called concurrency control.

You can use the EDIT command to modify data when the following conditions are met:

You have not used the DISTINCT option in the command.

You have rights to change the data in the specified table. Access rights are assigned with the GRANT command.

Notes:

·	The EDIT command will display the data within a multi-table View (a View based on multiple tables), but the data will not be editable.

·	A View with a GROUP BY parameter is also not editable.

Examples

Example 01:

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

EDIT * FROM transmaster ORDER BY custid

Example 02:

The command below displays the following columns from the customertable: custid, company, custaddress, custcity, custstate, and custzip. The only rows that are displayed are rows that have 100 for a customer identification. The custid and companycolumns are specified to be read-only and cannot be edited. The command specifies that the display of the company column is to be ten characters wide.

EDIT custid=READ, company=10=READ, custaddress, custcity, +

custstate, custzip FROM customer WHERE custid = 100

Example 03:

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

EDIT ALL FROM customer OPTION WINDOW_STATE MAXIMIZED|CAPTION Customer Data

Example 04:

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

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