Editing 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. The field delimiter, quoting character, and escape character
for the results are controlled by the isql_field_separator, isql_quote, and isql_escape_character options, respectively. These
options can be viewed and changed in Options window in Interactive SQL.

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. See Recalling commands.

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:

select columns from a table with a primary key, but do not select all the primary key columns.

attempt to edit the result set of a JOIN (for example, if there is data from more than one table in the result set).