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

What is 'sleep' in sync point?

1041

---

Diff b/w Health care domain and Banking Domain?

4644

---

i need qtp tutorial. pls send it to sridhar.k151@g mail.com

2022

---

How to check feasibility of the appliction?in automation testing?

1917

---

What is the difference between qtp and selenium?

962

---

Hi Samrat, Thank u very much, what u said it is right.

1834

---

i am a begnner so am learning Error handling :tried using Recovery manager didnt work i want to be able to handle errors , e.g. if while running the test the folwoing does not show up then how can i use the If then else and goto next step in the test, as in many scenarios it does not show up Browser("The Shopping Channel -").Page("The Shopping Channel -_8").Image("easy pay").Click

1953

---

Hi Every body please explain me in steps to use checkpoints and object Repositories in QTP for Flight Reservation application please tell me the steps for this its urgent pls thanx for urs answers

2009

---

can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process

1714

---

Hi we are using QTP9.0 for Seibel Application and this seibel application will give you a popup messagebox which is of web , so qtp takes 3 mins to recognize the messagebox and to click on it , we have more number of messageboxes like this . please suggest me some solution

2080

---

How to analyzing test results using quicktest professional?

1120

---

How QTP support all types of applications (platforms)?

4462

---

What is the standard timing delay for web based application in qtp?

1023

---

explain structured testing? plz guys with exp. do answer

1816

---

how to disable the pop ups through QTP using a script

2197

---