Editing application data

Online Help

Introducing Progress DB Navigator : Tasks : Common tasks for supported databases : Working with application data : Editing application data

To edit the data in a table:

1. Select a table name in the DB Structure view. Right-click to display the context menu.

2. Choose Edit Table Data.

The Editing dialog appears, displaying the data from the selected table.

Note: The browse expands automatically to the maximum size of the row.

You can set the number of rows displayed in the SQL Results row limits field of the DB Navigator preferences. You can also filter the rows displayed by entering a SQL WHERE statement. For example, in this image, statement displays only those rows in which the value in the Balance column is greater than 10000.

Both editing errors and SQL syntax errors appear at the bottom of the view.

Note: (For OpenEdge databases only) ABL triggers do not execute when you modify data in the Editing dialog. For example, if you use a trigger to prompt for user confirmation before committing a change, the trigger does not execute. However, since DB Navigator uses the OpenEdge SQL interface, Java triggers do execute.