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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL » Result sets in Interactive SQL

 

Copying rows, columns, 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.

Prerequisites

There are no prerequisites for this task.

You must have executed a query to have a result set.

Context and remarks

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

You can also change these options from 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.

 Task
  • In Interactive SQL, retrieve the result set you want to copy.

    Option Action
    Copy one row

    Right-click any cell in the row and click Copy Data » Rows.

    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.

    Copy one column

    Right-click any cell in the column and click Copy Data » Columns.

    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.

    Copy a cell

    Right-click the cell you want to copy and click Copy Data » Cells.

    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.

Results

The selected data is copied.

Next

You can paste the selected information into other applications.