Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Administering Your Database » SQL Anywhere graphical administration tools » Using Interactive SQL » Editing result sets in Interactive SQL

 

Copying rows from an Interactive SQL result set

You can copy cells, rows, and columns directly from the result set in Interactive SQL and then paste them into other applications. Copying rows and columns copies both the column headings and table data into the clipboard. You can only copy one column at a time.

Copied data is formatted according to the following Interactive SQL options:

You can also change these options from the Interactive SQL Options menu, by choosing Import/Export.

If these options are set to their defaults, the copied data is comma-delimited and all of the strings are enclosed in single quotes.

To copy rows from the Interactive SQL result set

  1. Select the row(s) in the result set that you want to copy.

  2. Right-click the selection and choose Copy » Copy Selected Row(s).

    The selected row(s), including their column headings, are copied to the clipboard.

    You can now paste the row(s) into other applications.

To copy a column from the Interactive SQL result set

  • Right-click the column you want to copy and choose Copy » Copy Column. You can only copy one column at a time.

    If the Results pane does not contain the entire result set, you are prompted to fetch the remaining results before selecting them. Otherwise, only those results that have been fetched so far are selected.

    The column, including the column heading, is copied to the clipboard.

    You can now paste the column into other applications.

To copy individual values from the Interactive SQL result set

  • Right-click the value in the result set that you want to copy, and choose Copy » Copy Cell.

    When you do this, no column headings are copied—only the data is copied to the clipboard, and no quoting is done.

    You can now paste the contents of the cell into other applications.