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)
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of recording modes in qtp? Which will be used when?
What is the basic concept of quicktest professional?
What are the technologies supported by qtp?
Hi. please provide license key for QTP 9.2, I have windows XP on my machine Thanks in Advance, moreshwar
What ate the Technologies supported by QTP?
What is the use of text output value in quicktest professional?
How to record a qtp script ?
1.Qtp suppots Unix& linx or not 2why qtp suppots shell script.
Write a script to customize the test results in PDF and HTML format.
What is throw object?
what is the difference between development and testing
1.How do u prepare the test suits in QC? 2.How do u convert requirements to test plan in QC?
How do you compare the structure of 2 tables in database and check whether they are similar using qtp.
Where should i find checkpoint and virtual objects's Object properties and values in the QTP 9.2 Means where checkpoints or virtual objects related data will store If i want to get the runtime object properties how can i use Getroproperties on Checkpoints
Hi, I'm a beginner in QTP and planning of a certification in QTP, but have no idea about it :P. Could anyone please tell me what certifications that a QTP- beginner can take? What is the fees and the syllabus for the certification? Please reply soon. Thanks Vidhya