Answer Posted / ashish srivastava

Hi All,

As per your question i would like to suggest that make sure
that your are passing the same query from the from end as
you are using it in the back-end
as per the question your database having 100 records ,so
make sure that the query ur passing should not have any
"WHERE" AND JOINS statements in the query . If you have then
the Result will be filter and you will get the record
matching to the criteria in the query

FOR USING IT IN QTP PLS write the below code

Dim connect, recset

connect=CreateObject("ADODB.Connection")

recset=CreateObject("ADODB.RecordSet")

connect.Open"Provider=SQLDB1,Userid="Your ID",
Password="Your Password",Database="Your Database"

recset.open "Select Count(*) from your table name",connect

msgbox recset

How do you configure QTP AND Test director?

1940

---

am not having intrest in coding lang like c c++ java etc can i choose Testing tools as my carrier and please suggest me which tool is good (suitable for me)

1714

---

Explain how Does Run time data (Parameterization) is handled in QTP?

1056

---

How you can write contexts to text file in qtp?

1112

---

requirement is for combo box your expected value is str= "Denver.Frankfurt.London.Los Angeles.Paris.Portland.San Francisco.Seattle.Sydney.Zurich" you must get the text in combo box and need to compare them how

2005

---

What is quicktest professional window?

995

---

What is checking bitmaps?

1022

---

What is use of object spy?

1087

---

Explain the differences between table and db checkpoints?

1003

---

how to do the batch testing in test director using manual testing procedure?

2384

---

Plz Explain AUTOMATION REFERENCE MODEL?

2223

---

How to associate shared object repository to test in qtp?

1006

---

Can I change properties of a test object?

1151

---

Hi all can any one give me roles and responsibilities for QTP (not WINRUNNER)

3712

---

What is keyword view in qtp?

941

---