Editing data

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 Help > Contents, right-clicking an item and selecting What's This, or by pressing F1.

To edit data:

  1. From Optim™ Designer, click Tools > Edit The Edit Options windows opens.
  2. Enter a Table Name or Named Access Definition, select Initial Display or Mode options, and click OK. The Table Editor window opens.
  3. 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 Tools > Undo.
    • 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....


Feedback