Connect to '.

Using the Database command from the Application category and selecting SQL Query Option specify a SQL Query

Execute SQL Statement: Select * From OrderMaster Where OrderDate $UserOpeator$ #$UserValue$#

$UserOperator$: It is a variable which is accepted by the user through the Prompt command.

$UserValue$: It is a variable which is accepted by the user through the Prompt command

Inside the Loop Block, specify the Keystroke to paste the values of each column of the Dataset using the variable $Dataset Column(1)$ in excel cells.

Keystrokes: $Dataset Column(1)

Note: To access values of different columns in the dataset use the index 1,2,3 etc with the System Variable $Dataset Column$.

Also specify the Keystroke command to move to the next cell in the Excel sheet

Keystrokes: [RIGHT ARROW] (Screenshot 2).

This tutorial demonstrates use of one of very powerful feature, 'Database' applications. Use this when you want to perform a task based on the data from any database.