Parameterization in QTP 9.2

Parametrization in QTP is a process of replacing all the constants within the test script into variables (parameters) so that we can reuse the same script with different sets of data.

Parametrization in QTP happens in 4 ways.

1. Database Parameters.
2. Action parameters.
3. Environment Parameters.
4. Random Parameters.

Database parameters can be set by Internal data sheet, External data sheet and Excel parameters.

What is Data Driven Testing in QTP 9.2?

Data driven testing is the process of passing huge sets of data into Application under test using a data sheet. The data sheet closely resembles to the excel spread sheet. The concept of data driven testing can be achieved using data table parametrization.

Let us look at how a Test in QTP is organized. A test has one or many actions and each action can have one or more functions. Now each action has one local object repository and a local data sheet, like wise all the actions have one local data sheet and local object repository but the entire test has one Global data sheet which all of these actions can have access. Look at the figure below.

What is a Data Table in QTP?

A data table is a combination of local data sheet and global data sheet. Every action has one local data sheet and local object repository but only one global data sheet for the entire test. There may be any number of actions for which that many number of local data sheets are created but for all these actions together has one global data sheet. All actions can access the global data sheet.

Every QTP test will have one global sheet. There is no action associated with a global sheet and global sheet can be accessed by all the actions within the test.

To work with the data table in QTP we make use of data table object. Data table is a utility object in QTP.

What is a Utility object in QTP?

Utility objects are the objects provided by the quick test library used to enhance our test scripts. Data table objects have design time data table and Run time data table.

The data table that exists during script design is the design time data table. The moment you click the run button we enter the run session then the design data table gets converted into run time data table and all the data table objects, properties and methods will be applicable only to the run time data table and the design time data table s not affected. Any manipulations during run time done are written in the run time data table.

Note: data table object is nothing but the run time data table.

Syntax

Data Table.value (parameterid, sheetid)

Example:

DataTable.Value(1,1)
DataTable.Value(2,1)

Window(“Flight Reservation”).WinCombo(“Fly From”).Select Data Table.Value(2,1)

To insert a value in the data table like the order number generated during inserting a order we write the script like this.

Ord_Num = Window(“Flight Reservation”).WinEdit(“Order No:”).GetROProperty(“text”)

Data Table.Value(5,1) = Ord_Num

What is Data Table Object in QTP?

Data table object is a utility object in QTP that points to the run time data table.

What is Value Property in QTP?

Value Property is the data table default property used to set or retrieve values from a specified parameter within the data table. Value property takes the parameter id and the sheet id as part of its syntax.

Data Table.value (parameterid, sheetid)