Greetings friends ,
Hope all of you are doing well.
When I run a test, is it possible for me to for me to take
each row from the data table , once at a time.
In other words,if i have 10 rows in the global data table,
say data1,data2, data 3...and so on up to data10.
Can I have the value of data1 when I run a test, and next
time when I run the same test (say next day), it should
skip data1 as it has already used it and go directly to
data 2 ???
Would be great if anybody can help me out know in this
issue.
Thanks & Regards !!
Answers were Sorted based on User's Feedback
Answer / hemakumar.m
1)Answer
as per y knowledge there is no function to get entire row
2) Answer
U can maintain one colummn Ex:Status in excel sheet,when u
used particular data and u got expected result u palce some
text like useddata for used one and blank for unused data
(default) in u r excel sheet.u can write programme like
that when the status colummn value is used data skip that
step.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vik
Thanks Mr.Hemakumar
Realy appreacite your time.
Actually, I need QTP to select a new user name each time
automatically. I want to pre-enter 50 names in the excel
data table and accordingly let QTP to take 1 value each
time.
So, if I can understand your answer right, there needs to
be a column named "Status". Assuming the first field
says "Raj", then QTP uses it because it has not been used
before.
However, next time with a new test how would you let QTP
know that it has already used "Raj". Have we got to
capture "Raj" as a already used data and then compare with
next test. If the value matches , then move to next field
to fetch the next field value. Am I right ?
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / deepakm82
Hey Vik,
As far as i understand ur question,u saying that u have 50
users which use 50 different sets of data.
You have already pre-entered the 50 users and so u also
must have pre-entered the 50 rows of data used by 50 users.
What hemakumar is saying is that you can have a column
STATUS which gives you the position of the user.
Suppose 'Raj' is the first user and 'Vik' is the 2nd user
then STATUS would say 1 for 'Raj' and 2 for 'Vik'.
Now while running the QTP you can use following:
Datatable.SetCurrentRow("STATUS")
Depending upon the STATUS column the data row would b
selected.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kashinath hajare
'Please Check Following code. In this code "Is_Required" is
defined in Datatable( Column Name). Make it as "1" or "0",
as per requirement. If value of this column "1", only that
column will execute.
iScenCount=DataTable.GetSheet("Global").GetRowCount
'Traverse throgh master datasheet to execute the scenario
For iRowCounter= 1 to iScenCount
DataTable.GetSheet("Global").SetCurrentRow iRowCounter
If trim(DataTable.Value("Is_Required", "Global")) Then
'Your Script code will be here
End if
Next
Is This Answer Correct ? | 0 Yes | 0 No |
1)what is the Exact Meaning of Environment Variables? 2)what is Compile Module in QTP? what exactly it contains Functions or Actions?
1.what is test automation life cycle?
How to test a web application using QTP?there is no any .exe file in web app,then how we can take the application for testing
what are the design objects in qtp
Can we call a parameter from an action to other action?
how do u prepare Test Environment ?
How to map the test cases to requirements in QC?
i have written some lines of code today..tommorow some lines of code deleted in middle of that code..how to handle this type of script
Pls explain me the difference between ........ Description.Create and CreateObject
what properties do use to identify a browser and page while using descriptive programming?
how to pripare BRS/FRS Document for different projects?
hi i am working with vbwindow on qtp.first i am openning qtp whenever open qtp my application not open that time generated error like "Runtime error 0" and fatal error:automation error how to solve this problem pls tell me