QTP Data Table Having 10 records with 10 to 15 fields(lets
say).now i want to get alternative records from datatable.pls
can any one answer it?

Answer Posted / pushkar1206

datatable.AddSheet"pushkar"
datatable.ImportSheet "C:UserspushkarDesktopBook1.xls","Sheet1","pushkar"
rw=datatable.GetSheet("pushkar").GetRowCount
clm=datatable.GetSheet("pushkar").GetParameterCount
For i=1 to rw step 2
For j=1 to clm
a=datatable.GetSheet("pushkar").GetParameter(j).valuebyrow(i)
msgbox a
Next
Next

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In qtp, how you can get the last character from a string?

556


On what document base Descriptive programming is written if build is not yet ready ?

882


RECENTLY I PLACED IN QTP..HOW TO IMPROVE VB SCRIPTS KNOWLEDGE? IAM STRUGGING TO WRITE THE AUTOMATION SCRIPTS? ANY BODY TELL HOW TO IMPROVE QTP SCRIPT SKILLS?

2190


Can any body please tell me the steps of keyword driven framework of QTP.

1570


can u explain relative path architecture framework in qtp?

1563






What is the difference between analog and low level recording?

626


What do you to script when objects are removed from application?

618


Hi guys, Our company has started to automate testing and started using the tool QTP.Iam new to QTP and I have the following questions to ask. Would appreciate if anyone could give me a hand on this and explain things in a detailed way. [1] Bugs outside checkpoints: I know that I can easily make the QTP do what I want inside the application. Also, I know that I can insert some checkpoints and that the qtp will notice if those conditions are not met. However, there are bugs and problems that might not be connected to a checkpoint (system crash, database error, losing session/logout etc.); how can I make sure that the QTP will notice such problems as well and flag a test as failed. [2] How to tell the QTP that when a particular statement is "false",it should flag it as, test failed and show in in the test report. In short how to tell the qtp that a test is false from the script so that it shows it in the report For Eg:- if(true) test passed // how to instruct qtp else test failed // how to instruct qtp [3] Test script portability: we are having several environments; If I record a test on User Interface, obviously, the qtp will save the URL; however, how can I make the qtp run the tests so that the url is provided dynamically. Is there a possibility to parameterize the web server.Is this the way to do it.I dont know? [4] Test management: How do I manage the tests? I guess we will be doing it in Quality Center, yet, it’s not perfectly clear to me how we will be doing that. [5] Running scheduled test sets: How do I group tests to a certain test set? How can I make this test set run at a predefined time? [6] Test maintenance: What do we need to do beforehand in order to enable for easy test maintenance, meaning small adjustments in tests? [7] Reports: What kind of reports on test results are available (either QTP or Quality Center)? Thanks in advance and hoping for an answer. Jen

1479


what is the diff between manual test plan document and automation test plan doc.can u explain indetail.

1646


Explain different types of checkpoints?

562


Give me some real time point of way where exactly we can conduct audits?

1503


If the objects hierarchy is changing from build to build, then how you will handle that condition?

621


Explain different recording modes?

585


Create flight reservation login descriptive programing (Condition: Remove the value and substitute with a variable, and then call the validation from Excel) Plz help me....... very urgent.........

1582


Explain runtime dynamic settings?

2028