Use the Table Editor to browse and edit sets of relationally
intact data in database tables. The editor handles an arbitrarily
complex data model consisting of any number of tables and relationships
and ensures a referentially intact set of data.
Use the help facility in the Table Editor to obtain more
information about a specific topic or function. You can open a help
window by selecting , right-clicking an item and selecting What's
This, or by pressing F1.
To edit data:
- From Optim™ Designer,
click The Edit Options windows opens.
- Enter a Table Name or Named
Access Definition, select Initial Display or Mode options,
and click OK. The Table Editor
window opens.
- Edit one or more tables at the same time.
Commit
changes to the database by moving the pointer to a different row or
by using menu options. 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. The editor allows you to restore
the data you modify to a specific commit point.
A fetch set
is the set of rows the editor reads from a single table in the database.
- To undo changes and restore rows to the original versions obtained
in the current fetch set for all tables, select .
- To undo a change for a row, right-click the row and click Undo.
- To display each successive version of the row committed in the
current fetch set, and the original version of the row in the fetch
set, right-click the row and click Undo....