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

is it possible to add sheets to excel at runtime

3959

---

Explain the concept of object repository and how qtp recognises objects?

989

---

Explain the concept of object repository and how quicktest professional recognises objects?

968

---

before launching qtp, we need to close all the open browsers u dont know what are all the browsers either it might be ie,mozilla etc and u dont know how many brosers are open.... u need to close all these before launching qtp.. can anyone plz temme d solution...

8054

---

How to suppress warnings from the test results page?

974

---

How many ways we can parameterize data in quicktest professional (qtp)?

1021

---

How to find a window is minimized or not

1832

---

hi, FOR 3+ QTP INTERVIEW, FOR EXAMPLE WE PUT ONLINE BANKING SYSTEM PROJECT IN OUR RESUME, IN PROJECT MANAGER ROUND...WHAT R THE MAJOR QUESTIONS ARE ASKED IN P.M? PLS TELL ME ATLEAST 10 QUESTIONS?.....AND IF POSSIBLE POST ANSWERS ALSO....

2873

---

HOw to add the recovery file at runtime to the test file .

2127

---

Explain the types of properties that quick test learns while recording?

973

---

can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?

2064

---

Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji

1796

---

What are the advantages of a Hybrid framework?

1076

---

can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process

1733

---

what is vmodel?advantages and disadvantages of vmodel?

2095

---