SetSQL method: AESection class

Syntax

SetSQL(action_type_string, string)

Description

The SetSQL method replaces the SQL associated with the given action type in the current step in the base section with the SQL in string. The current step is the latest step that was added using AddStep. The action types are:

• DO_WHEN

• DO_WHILE

• DO_SELECT

• SQL

• DO_UNTIL

Note:

All action types must be passed in as strings with quotation marks.

If the action specified does not exist in the current step, an error occurs.

You can use a SQL object as string.

&SECTION.SetSQL("SQL", &SQL);

Parameters

Parameter	Description
action_type	Specifies the action type of the current step that should be changed. This parameter takes a string value.
string	Specifies the SQL to be used to replace the SQL in the current step.

Returns

None.

Example

See AESection Example.