how we do database testing with qtp using descriptive
programming?
- 22 Answers
- 34904 Views
- Nutrins, Rohit Technologies, Symphony, Syntel, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Hey guys......sorry if anybody is hurt....even my english
is not that good.....but i was searching for answer and
when i read this, it was frustrating to read .....maybe
Chandra is very good at QTP....mine was just a natural
reaction.........
Sorry Chandra....but answer in such a way that people can
understand
Now all of you please end this and give a correct answer..
Sirisha...has done nice job explaining...
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / ritesh
Just looked into the comments posted and found that
visiting this forum is a waste of time where instead of
answers people are busy contradicting each others statements
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / harikrishna
Database testing is all about data validation & data integration.The correctness of new data insertion is called data validation.
The correctness of changes incurred due to insertion of new data from parent table to child tables is called data integrity
All we have to know is DML(select,insert,update,delete) commands in sql to use to dbase testing
ADODB-we use this to connect to any kind of dbase(sql,oracle..etc)
rso(Record set object)-a temp buffer where we use to store for retriving information frm dbase.
here am posting an example hw to connect a dbase and count no.of rows in a table via qtp
Option explicit
Dim cono,rso,n
Set cono=createobject("ADODB.connection")
cono.Open("DSN=hari")
Set rso=createobject("ADODB.recordset")
rso.Open "select * from harikrishnaa",cono
n=0
While rso.EOF<>true
n=n+1
rso.MoveNext
Wend
print "no of rows in record set is"&n
Set rso=nothing
Set cono=nothing
..................i used my own crated DSN.instead you shud use connection strings(which are ready available in google search engine)
HAPPY TESTING ALL.plz write comments as i hav used my time 4 u
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chandra shekhar
Thanx you Mr. k.chandra sekhar
you halpfool answering was to me...well very done.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / abk
hay guys,
I agree with dinesh.We should encourage Mr. chandra shekhar
instead of finding negative points.He tried to help us. We
all should appreciate him.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raghavendra prasad
Mr. Mukesh, It takes great amount of interest and guts to come out and try to answer a question. I have seen people of other Asian countries speak worse English. If you can't comprehend what he is trying to communicate, ask!!! Respect your country men dude.Being from a country of many languages, English just a common language used to communicate among ourselves. Respect your country men and it will be returned to you. Good luck!!
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raghavendra prasad
Anmol,
Literacy is not in language. Its in the attitude towards people. Other than that humiliating comment of yours i haven't found a single word that answers the question. Shame on you!!!
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / maharshi
any body can suggest how to remove this buttler english
question?
| Is This Answer Correct ? | 7 Yes | 10 No |
Hi All. Can you please explaing what is checkpoint? How it Will Work? what is meaning of "check checkpoint ("proprtname").how it will compate with expected value? Thanks in Advance............... Lakshmi
what are the different kinds of frameworks in automation?
Will QTP Support Visual Foxpro Applications? If yes please tell me whether I need to install any additional addins for that?
1. IS A VIRTUAL OBJECT USED WHEN THE LABEL IS NOT RECOGNIZED BY QTP
Can we directly automate testscripts accrdoing to requirements? WHY ?
what is object repository?
What is qtp window?
1.How to find in which row or column,string "Hyderabad" exist in excel sheet? 2.How to find how many times character "a" repeated in a given string "Koteswararao"
what is run-time object property in Object spy in QTP9?
why can't you use excel directly in qtp. why we want to import excel data into Datatable.
What is meant by Environmental variables?2 types r there know…can u pls explain clearly?
what is the Command used to start the QTp from Run.(start-> Run)
WinRunner 
