Method to Add Parameter to the Local sheet
DataTable.LocalSheet.AddParameter “Time”, “5:45”
Steps to import the data from database table:
1.Right click on the required sheet of the data table
2.Select Sheet --> Import --> From database
3.Select the radio button “Specify SQL statement manually”
4.Provide maximum number of rows if required
5.Click on Next
6.Create the connection string and provide the SQL statement
7.Click on Finish
Different Ways to Parameterization:
We can parametrize the script in 3 different ways
1.Using the Data Driver Wizard
2.Using the Keyword view
3.Using the Object Repository
Note: Using the Data Driver Wizard & Keyword view, we can parametrize the test data value. Where as Object Repository is used to parametrize any physical property of the text.
Steps to Parametrize using DDN:
Refer to pg no-
Steps to Parametrize using Keyword View:
1.Create the required basic script
2.Go to keyword view
3.Select the required value to be parametrize
4.Click on configure the value option
5.Select the radio button ‘Parameter’
6.Provide the parameter name & the location as Global or Local sheet
7.Click on Finish
8.Repeat the above steps to parametrize any values from the keyword view
Steps to Parametrize using Object Repository:
1.Select Resources --> Object Repository
2.Select the required object from the left panel
3.Select the required property from the right panel
4.Click on configure the value option
5.Select the radio button parameter
6.Provide the parameter name & location
7.Click on Finish
Parameter Types:
While parameterizing a value, we can select the parameter type to be one of the following 3 types:
1.Data table
2.Environment
3.Random Number
Steps to work with parameter type Data table:
Refer to Pg no-
Steps to work with parameter type Environment:
1.Create the required basic script
2.Select Tools --> Data Driver
3.Select the value to be parameterize --> Click on Parameterize Button
4.Click on Next --> Click on Parameter options
5.Select the parameter type as ‘Environment’
6.Provide environment variable or select from the drop-down for any system defined variable
7.Click on OK --> Click on Finish
Eg: Vbwindow(“VbWindow”).VbEdit(“VbEdit”).Set Environment(“Num1”)
Steps to work with parameter type Random Numbers:
1.Create the required basic script
2.Select Tools --> Data Driver
3.Select the value to be parametrize --> Click on Parametrize Button
4.Click on Next --> Click on Parameter options
5.Select the parameter type as ‘Random Number’
6.Provide the range for the random number to be generated.
7.Provide the parameter name --> Click on OK
