Copying columns, rows, and cells 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 by clicking Options » Import/Export.

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

 Copy rows from the Interactive SQL result set

  1. To copy one row, right-click any cell in the row and click Copy Data » Rows.

    To copy multiple rows, hold the Ctrl key while clicking cells in the rows, and then right-click and click Copy Data » Rows.

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

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

 Copy column(s) from the Interactive SQL result set

  1. To copy one column, right-click any cell in the column and click Copy Data » Columns.

    To copy multiple columns, hold the Ctrl key while clicking cells in the columns, and then right-click and click Copy Data » Columns.

    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.

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

 Copy cells from the Interactive SQL result set

  1. Right-click the cell you want to copy and click Copy Data » Cells. To copy multiple cells, hold the Ctrl key while clicking cells, and then right-click and click Copy Data » Cells.

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

  2. You can now paste the contents of the cell(s) into other applications.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1