Using the SQL Editor

Once you have defined the given Database Action via the action's properties, General tab, use the following steps to add your SQL statement.

  1. With the lower panel properties for the action still open, select the SQL Editor tab.

How to

From this point enter your SQL database query just as you would on the command line or any SQL editor. For example, if you are inserting data at runtime for a given test your workflow may be something like CREATE TABLE , INSERT INTO , SELECT * FROM .

What you should see

In such a scenario, you will use the first database action to create the table. This is just the first action in the scenario.

Define the Output type per action just as described above until you arrive at the necessary workflow (shown below in Clip Editor, List view).

The Output type selected for each action will determine what you see in test Results.