Micro Focus QTP (UFT) Forums
Regarding Parameterising Values using Data Tabke - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Regarding Parameterising Values using Data Tabke (/Thread-Regarding-Parameterising-Values-using-Data-Tabke)



Regarding Parameterising Values using Data Tabke - vijaya16 - 11-19-2009

Hello All,

I have started off qith QTP 9.1 recently.
My Question is as below:
I need to run Regression testcases using QTP9.1.I have recorded a script following the End to End flow.Now my question is how to genraically specify values as theye are multiple values that need to be passed for the same login for multiple test cases.Pls help me with the code..I was asked to use Data Table but how to implement data table i am not aware of..Pls suggest.

Code below :
Pls find the below code where i need to pass different values for Prcing Account Types :
Code:
Browser("Siebel Media Systest 10.9.2").Page("Siebel Media Systest 10.9.2").WebEdit("_SweUserName").Set  "abcd"
Browser("Siebel Media Systest 10.9.2").Page("Siebel Media Systest 10.9.2").WebEdit("_SwePassword").SetSecure "4b02abb21d04b0e43aa386e107cc583c3477"
Browser("Siebel Media Systest 10.9.2").Page("Siebel Media Systest 10.9.2").WebEdit("_SwePassword").Submit
SiebApplication("Siebel Media Systest 10.9.2").SiebPageTabs("PageTabs").GotoScreen "Accounts Screen"
Browser("Siebel Media Systest 10.9.2_2").Page("Siebel Media Systest 10.9.2").Frame("View Frame").SblButton("Go").Click
SiebApplication("Siebel Media Systest 10.9.2").SiebScreen("Accounts").SiebView("All Accounts").SiebApplet("Account").SiebButton("Query").Click
SiebApplication("Siebel Media Systest 10.9.2").SiebScreen("Accounts").SiebView("All Accounts").SiebApplet("Account").SiebPicklist("Pricing Account Types").Select "Academic"
SiebApplication("Siebel Media Systest 10.9.2").SiebScreen("Accounts").SiebView("All Accounts").SiebApplet("Account").SiebPicklist("Account Class").Select "Regular Account"



RE: Regarding Parameterising Values using Data Tabke - Saket - 11-19-2009

This should help you
1.Create parameters as column in your datatable local/global (as per your requirement) sheet for different fields like username. password ..
2.use these parameters in your statements using Datatable like the code below
Code:
Browser("Siebel Media Systest 10.9.2").Page("Siebel Media Systest 10.9.2").WebEdit("_SweUserName").Set Datatable("UserName", dtLocalSheet)
Browser("Siebel Media Systest 10.9.2").Page("Siebel Media Systest 10.9.2").WebEdit("_SwePassword").Set Datatable("Password", dtLocalSheet)

Same for rest of statements
...



RE: Regarding Parameterising Values using Data Tabke - v_selvam - 11-19-2009

1. Create columns for what ever inputs you want to parameter in the datasheet
2. then follow the Saket's intructions.

or

Use the data driver wizard in the QTP.