Edit Result Sets in Interactive SQL

Once you execute a query in Interactive SQL, you can sort and edit the result set to modify the database. You can also select rows from the result set and copy them for use in other applications.

Interactive SQL supports editing, inserting, and deleting rows. Editing the result set has the same effect as executing UPDATE, INSERT, and DELETE statements. After editing a result set, the equivalent INSERT, UPDATE, and DELETE statements are added to Interactive SQL's command history.

To edit a row or value in the result set, you must have the proper permissions on the table or column you want to modify values from. For example, if you want to delete a row, then you must have DELETE permission for the table the row belongs to.

You cannot edit a result set if you:

Editing the result set may fail if you:

When editing fails, an Interactive SQL error message appears explaining the error, and the database table values remain unchanged.

• Editing Table Values from the Interactive SQL Result Set
  You can change any or all of the values within existing rows in database tables, provided that you have UPDATE permission on the columns being modified. In addition table editing must not be disabled.
• Disabling Table Editing
  You can disable table editing via the Options window in Interactive SQL.
• Insert Rows into the Database from the Interactive SQL Result Set
  Interactive SQL allows you to add new rows to a table. You tab between columns in the result set to add values to the row. You must have INSERT permission on the table to add new rows.
• Deleting Rows from the Database Using Interactive SQL
  You can also delete rows from a database table in Interactive SQL. You must have DELETE permission on the table to delete rows.
• Copying Rows from an Interactive SQL Result Set
  You can copy rows directly from the result set in Interactive SQL and then paste them into other applications.
• Copying Columns from the Interactive SQL Result Set
  You can copy columns directly from the result set in Interactive SQL and then paste them into other applications.
• Copying Cells from the Interactive SQL Result Set
  Copying an individual value copies only the data to the clipboard. No column headings are copied and no quoting is done.
• Sorting Columns in an Interactive SQL Result Set
  Sort the results by a specified column.