Edit Data Tab

Edit Data Tab

Right-click a user table in the Database Explorer and select Edit Data to launch the Edit Data tab. The data grid displays the records in the table. You can modify the values and submit the changes to the database. When you navigate away from the row you are editing, the Database Viewer submits the modified values to the database.

Note You cannot edit tables that do not contain primary keys. If the database provider used for the connection does not support the methods required to retrieve the meta-information needed for the submit operation, selecting Edit Data from the context menu results in an error.

You can modify the existing value of a cell to null or specify a null value in a new record by pressing <Ctrl+Delete> in that cell. Entering an empty string to specify null might result in a data type mismatch error for most column data types.

The Edit Data Tab contains the following options:

  • Submit —Submits the modified data to the database.
  • Refresh —Retrieves data for the table. You can also press <Ctrl+R> to perform this command.
  • Print —Launches the Print dialog box. You can also press <Ctrl+P> to perform this command.
  • Export Data —Launches the Export Document dialog box.
  • Navigator Panel —This panel contains arrow keys to navigate through records in the data grid. The panel also contains the following buttons for edit operations:
    • Add(+) —Inserts a new row at the end of the data grid.
    • Delete —Deletes the selected row.
      Note A small arrowhead indicates the selected row in the data grid.
    • Edit —Edits the selected cell.
    • End Edit —Submits the change in the selected cell to the database.
    • Cancel Edit —Reverts the changes in the selected cell.
    • Undo Row Errors —Reverts all the changes made to a row that returned logical errors after submitting the modified data to the database.

The Edit Data tab also contains the following indicators:

  • Errors on Submitting Data —An error icon indicates when the submit operation returns errors, and a tooltip displays the exact error information. You cannot edit other rows in the grid until you resolve the existing error.
  • Errors in a Cell —If the data entered in a cell is incompatible with the column’s data type, an error icon indicates the error, and a tooltip displays the exact error information. You cannot edit other columns in the grid until you resolve this error.

The data grid context menu includes the following options:

  • Add New Row —Inserts a new row at the end of the last record in the table.
  • Delete Selected Row —Deletes the selected row from the database.
  • Undo Row Errors —Reverts all the changes made to a row that returned logical errors after submitting the modified data to the database.