Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9493 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saravanaraja
You can Copy & Paste to QTP:
Dim con,rs,ex,a,b,i
Set con=createobject("adodb.connection")
Set rs=createobject("adodb.recordset")
con.open"provider=sqloledb.1;server= ;uid= ;pwd= ;database=
"
rs.open"select count(column name) from table",con
Set ex=createobject("Excel.Application")
Set a=ex.workbooks.open("path of the Excel")
Set b=a.worksheets("sheet1")
i=1
Do while not rs.eof
b.cells(i,1).value=rs.fields("column name")
rs.movenext
i=i+1
loop
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sesha reddy
plz any one can send answer ,only reading the answers is
not godd friends .plz try to write the answers
from
sesha reddy
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / t.sunil kumar
Goto Insert>>checkpoint>>database checkpoint>>wizard will
open >> select the select sql statement manually>> click on
Next>> sepecify the connection string>> enter the query you
want. so that all the data available in the database will
appear in the table format. so that compare the data with
the user interface so that you can find the error in the
database.
plz let me know if there is any wrong in my answer.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ashok
Using QTP ,and make appropriates db connection and Query to
get a data in Record Set from data base and compare that
data with front end dable to find bugs.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chandana
Dear Ashok u told the processor ? can u explain me in detail
with steps Plz (chandana)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / lotr
Good reply Sunil. I guess they must have replied if that
solution worked or not !!
| Is This Answer Correct ? | 0 Yes | 1 No |
How many ways we can parameterize data in QTP?
Hello Everybody, Please tell me the concept of recovery management in QTP by giving any practical example of it. Thanks, Gaytri
QTP supports both client server and Web applications. Does it support Plug-in?
How exactly you start scripting in QTP? In the interview he was not satisfied with my answer.Please post what is correct answer.
In QTP TEST DIRECTOR COMBINATION WHAT IS THE PURPOSE OF TEST DIRECTOR? In Somebody says to store test cases and design test cases.?ok fine , but In test director 5.0 , QTp not launching. what u do?
how to acess a test in RSA?
What is the method for maximize the application while we using Decriptive programming in QTP?
When to use shared and local object repository?
What type of VB script u had done in expert view?
What are the common defects found in your project? (in qtp interview)
How does qtp identify gui object?
How to perform action on objects, If two objects have the almost the same name ? example : Object 1 : "Entry of Items" Object 2 : "Items" Whenever I ask QTP to perform an action on Object 2 it performs action on Object 1. Note: The two objects are present in an Oracle Application tree.
WinRunner 
