Commit and Restore Data

Fetch Set

A fetch set is the set of rows Edit reads from a single table in the database. Each table has a unique fetch set. A new fetch set is retrieved when:

• A join is requested. The related rows in the joined table are fetched.
• The Refetch Rows button is selected to refresh the fetch set for the table.
• The Sort criteria are redefined for a table.
• The Selection criteria are redefined for a table.
• The SQL WHERE clause is redefined for a table.
• The position of the Join Arrow in an upper level table is changed, thereby changing the row in focus and fetching a new set of related rows for subordinate joined tables.

Pending Status

When you make changes to a row, the row is placed in Pending Status. Rows in Pending status can be reset, committed to the database, or evaluated.

Commit Data

You can commit changes to the database by moving the pointer to a different row. You can also commit changes using the shortcut menu. Each instance of a commit counts as an undo level. An undo level is defined as a change to a row that is committed to the database.

If an error condition results when you attempt to commit data to the database, the data is not committed, but the attempt still counts as an undo level. Edit allows you to restore the data you modify to a specific commit point.

The number of commit instances you can undo is limited by the maximum number of undo levels per row specified on the Specify Edit Preferences dialog or the Edit tab in Personal Options. Refer to the Common Elements Manual.

You can specify 1 to 20 undo levels. Select a reasonable value to satisfy your needs. Since each undo level must be stored while editing, a large number can affect the performance and speed of Edit.

Restore Data

Edit allows you to selectively restore data to a prior commit point using Undo. You can undo changes to an individual row, to an individual table, or to the current fetch set for every table displayed in the Table Editor (except changes to LOB data, which cannot be undone).

Choose from the following Undo options:

Shortcut Menu Undo Commands

Use menu selections to undo changes only to the row that you right-clicked.

Edit Window Toolbar Undo Command

Click to undo changes to all rows in the current fetch set for the table in the corresponding edit window.

Tools Menu Undo Command

Select Undo from the Tools menu to undo changes to all rows in the current fetch set for all tables displayed in the Table Editor.

Shortcut Menu Undo Commands

Right-click a specific row to display the shortcut menu Undo commands:

Undo

Removes the last change you made to the row in the current fetch set.

Undo…

Displays the Undo Row List dialog. The Undo Row List dialog displays each successive version of the row you commit in the current fetch set up to the maximum number of undo levels, and the original version of the row in the fetch set. The most recent change is listed first. If the number of versions exceeds the number of undo levels, a blank row is inserted before the original to represent the missing versions.

Click the version of the row to restore.

Undo All

Removes all changes to the corresponding row in the current fetch set.

Edit Window Toolbar Undo Button

Click the Undo button in the edit window toolbar to undo changes to all rows in the corresponding table in the current fetch set.

Tools Menu Undo Command

Select Undo from the Tools menu to restore rows to the original versions obtained in the current fetch set for all tables in the Table Editor.