Visual Data Editing

From DBArtisan
Jump to: navigation, search

Go Up to Session 7: Data Management

To start the Visual Data Editor, do the following:

  1. In the Datasource Explorer, right-click any table and select Edit Data. DBArtisan opens the Data Editor Filter dialog.
  2. In Columns, select the columns that are to be included in the editable data.
    You can also filter the editable rows by including your SELECT statement.
  3. Click OK.
    In Live mode, all changes are applied to the database when you move off of an updated or inserted row. Deleted rows are immediately removed from the database. Batch mode allows you to make changes and then save all when all are complete. The mode is controlled by a dropdown in the Data Editor toolbar.
  4. Experiment with editing your data, and when complete, on the Data Editor toolbar, click the Execute (blue arrow) button.
    DBArtisan commits your changes. Regardless of mode, all of the generated DML statements are viewable in the lower SQL window.
  5. Close the Data Editor pane.

Proceed to Working with Table Data - Create Insert Statements.