How to database testing by manualy?in my db having 100
records when i am retriving the data from db it shows in
frent end 30 records how to find bug using QTP?plz Exp
realtimers (Chandana)
- 7 Answers
- 8510 Views
- Wipro, I also Faced
- E-Mail Answers
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 This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is it possible to refer the same object for referring more than one object that are of different class using the descriptive programming approach? Suppose my code is 'To create the object named as obj Set obj=Description.Create() 'To define the values obj("title").value="IE" obj("type").value="text" obj("html tag").value="INPUT" 'To set the value Browser("IE").Page("Yahoo").WebEdit(obj).Set "xyz" Can I refer the "obj" object for the three objects like Browser,page and webedit objects? If so how?
What is environment variable in qtp and why to use it?
how did u use automating testing tools in ur job?
How to analyzing test results using quicktest professional?
If I change the object name in one action will it be updated in all the actions? Or not?
How to handle the exceptions using recovery secnario manager in quicktest professional?
Explain the difference between call to action and copy action?
What is text/text area checkpoint?
What is text check point and text area check point?
Can we record using all the modes in a single script? Explanation with example is appreciated
How to use output values in qtp ?
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)
There is an excel file of 1 to 100 sheets how you will iterate through it?
How to check feasibility of the appliction?in automation testing?
How you can replace string in qtp?
