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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » Query Editor Help

Columns tab Next Page

INTO tab


Use this tab if you want to assign results to variables.

Dialog components

Include INTO variables    Select this option if you want to edit the variable names in the INTO variables column.

Selected columns    This box lists all the columns you have chosen for your query.

INTO variables    This is a list of variables to receive the value for each select list item. You can type the variable names directly into the fields.

Results    Click Results at the bottom of the dialog to see the results of your query, or an error message if the query contains errors.

SQL    Click SQL at the bottom of the dialog to see the SQL code for your query.

About INTO

INTO is used in procedures and triggers only. It specifies where the result set goes. There must be one variable for each column.

More information