INTO tab

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

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 chose 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 window to see the results of your query, or an error message if the query contains errors.

SQL   Click SQL at the bottom of the window 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.

See also