Answer Posted / 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

Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.

2006

---

What is object spy in quicktest professional (qtp)?

954

---

What are the challenges you faced during you entire life automation ?

1519

---

what is the hierarchy to use properties in descriptive programming

1985

---

Hi Friends this is kumar i would like to request to all of you ,please help me to explain real time project with using qtp scripts i know basics of qtp but it won't workout on interviews,pls help awating to reply.

1826

---

What is Curd testing?

2322

---

Without using gui map editor we can recognize the application in winrunner ?

1056

---

What is quick test pro?

1062

---

What is the difference between per-action and shared?

1138

---

how to know no.of mails in our g mail by using vb-script

2233

---

What is environment variable in qtp and why to use it?

1010

---

What is a data driven test in qtp?

1032

---

What is data driver in qtp? Where we use it?

1021

---

How to add object to object repository in qtp9.0 Suppose for brower yahoo home page

1848

---

How you can make an action as re-usable action?

1129

---