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 |
What is Active Screen in QTP?
Can we write winrunner language i.e TSL in QTP tool?
How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)
the question was on what techonlogy u been working on i said VB then he asked me the addin for VB in Qtp?
Add parameters during time in each row in one column
Thanks....But can u tell me how i use the QTP for GIS with one Example...
what is recovery scenario in QTP? what is the need of the recovery scenario in QTP? what are the advantages of the recovery scenarios in QTP?
We are using the QTP version 9.0 where we want to call objects from global repository for a particular function at runtime for increasing the performance of framework.We are actually looking for loading the objects under test (OAT) dynamically when script runs and would like to unload the same once the execution of the script is completed.
How to use library files in QTP? how we can call these files in to script?
If there are some browsers opened and I don't how many browsers are open, Now I want to close all the browsers that I don't know how many are opened. What would be Descriptive programming for this in QTP using VB Script..??? Please send your answers.
How to analyzing test results using quicktest professional?
1. how can you handle exceptions without using recovery scenario?