How to call Datable values in the QTP program.
exp: I have two parameters like Email id and Password
this two i would like to add multiple entries in the datable
to use it.
What is the difference between Gobal/Action datatable

Answers were Sorted based on User's Feedback



How to call Datable values in the QTP program. exp: I have two parameters like Email id and Passwor..

Answer / manish

For multiple iteration we can use global data sheet.

Getting the value :-

Browser(" ").page(" ").webedit("Emailid"). set
datatable.value("Email id",dtGlobalSheet)
Browser(" ").page("
").webedit("Password")datatable.value("Password",dtGlobalSheet)
Global Sheet And Action Sheet
GlobalSheet :- Global sheet we can use for every action and
by default it run for multiple iteration depends on the
value in the global sheet.

Action Sheet :- Action sheet is for perticular action and by
default it runs only one iteration but we can change it to
run for multiple iteration depends on the value in the
action sheet from the action property.

Is This Answer Correct ?    5 Yes 2 No

How to call Datable values in the QTP program. exp: I have two parameters like Email id and Passwor..

Answer / lakshmi

Call DtValues in Qtp:-

(Ur data Present in Dt(Global/Action Sheet first u verify)
nd Then proceed with this script...

dim rc
rc=DataTable.GetSheet("Global/Action").GetRowCount
for i=1 to rc
Datatable.setCurrentRow(i)
invokeapplication "Give Flight appPath"
Dialog("Login").WinEdit("AgentName").set
DataTable("Email id","Global")
Dialog("Login").WinEdit("PWord").set
DataTable("Password","Global")
Dialog("Login").WinButton("OK").click
Window("FR").close
DataTable.SetNextRow
Next

Diff in Datatable:(As ur Req u can ...)

By Default Setting For Global sheet is:
Run For Multiple Iterations
By Default Setting For Action sheet is:
Run For One Iteration Only

Is This Answer Correct ?    2 Yes 0 No

How to call Datable values in the QTP program. exp: I have two parameters like Email id and Passwor..

Answer / xyz

datatable.rawvalue("emailid",dtglobalsheet)
datatable.rawvalue("password",actionsheet)

global represents the iteration of the test,

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More QTP Interview Questions

how do we add a new sheet to data table in QTP?

7 Answers   TCS, Wipro,


can u give one scenario for for PopWindow Exception & write Code for that?

2 Answers   Cap Gemini,


what are the metrics in general we use in testing.

6 Answers   TCS,


what is the extension for QTP files?

16 Answers   American Solutions,


How to make arguments optional in a function?

6 Answers   Liquid Crystal,






In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?

0 Answers  


What are the things(properties, and other details) will be recorded while recording an object using normal recording?

0 Answers  


how to evalute defects in QTP script?

0 Answers  


How can we close all webbrowsers which are opened in out desctop?

8 Answers  


We need to verify the user name & password in for the user validation. But we don't want to use the parameterization/ loop for user name and password. What is the way in scripting so that user & password will generate automatically.

11 Answers   Tech Mahindra,


Is it possible to convert QTP scripts to Silk scripts?

2 Answers   Sierra Atlantica,


without Qtp features can we automated?

1 Answers   IBM,


Categories