Skip to content

Editing a Result Set

Only in DbVisualizer Pro

This feature is only available in the DbVisualizer Pro edition.

You can edit a result set in SQL Commander in the same way as you edit table data, if all of these are true:

  • The statement is a query, such as a SELECT statement.
  • Only one table is referenced in the FROM clause.
  • All columns in the result set exist by name (case-sensitive) in that table.

If the result set can't be edited, a Read-only indicator is shown in the grid status bar. To see why, hover over the indicator or click it.

The Read-only indicator in the grid status bar

For performance reasons, metadata such as column information is saved in a local cache. If there is a mismatch between the local cache and the column metadata in the result set, the grid is read-only with an icon in front of the Read-only indicator.

The cache mismatch icon before the Read-only indicator

Clicking the icon will display a dialog with the details of the mismatch and options to compare what columns differ and to refresh the local cache.

The details of the cache mismatch

The diff window shows what columns don't match:

The columns that don't match

If you want results to always be read-only, you can enable the Make Result Sets Read-Only setting in the Tool Properties dialog, in the SQL Commander/Result Sets category under the General tab.