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)
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 to connect QTP to Testdirector
How do you do batch testing in wr & is it possible to do in qtp, if so explain?
Explain the concept of object repository and how QTP recognizes objects?
IF we use batch testing.the result shown for last action only.in that how can i get result for every action.
What r types of parametarizations?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
suppose i can done the project in automation tool with QTP in that time what i can say?
How to count the no of objects in XML file(QTP)
hi this is srinivasa(from blr) i complited my B.tech(e.c.e) in 2007 im searching job in s/w testing but idont have freshers resume for s/w testing please send some s/w testing resume for me(fresfers resumes only) advns thnks you
if devloper change only button names in present build then script will execute or not , why? Only gui changed.......
How exactly you start scripting in QTP? In the interview he was not satisfied with my answer.Please post what is correct answer.
What is log file?How to write log file code?
2 Answers Apps Lab, Value Labs,