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

I have developed and executed a script successfully, and saved the same to QC. When I tried to execute the script from QC, the script is not executing. What are the possible reasons?”

1169

---

Can you list some technologies that support qtp?

958

---

How many add-ins comes by default with quicktest professional?

950

---

How can I use Call dlls in QTP ?

2312

---

What is the syntax to call one script from another?

1050

---

Can any one say what exact diff between test->parameters, action properties-> parameters. after defining the parameters in test->settings, how can we access those parameters.(i know how to use action prop parameters)

2111

---

assume i have few url link how will i dynamically call then using descriptive programming?

2017

---

An action has both shared and local OR associated with it and both have the same object in them. In the test which one will be considered?

1012

---

How do we analyze the checkpoint results?

1037

---

What are parameterizing tests?

1031

---

How many number of actions possible in qtp?

1046

---

Hi, my requirement is to make a query in SQL using QTP. And i have to get the results of that query and i have to use those results for future testing. I created a driver but i dont know the code for using this Driver. please help me by providing the solution for y requorement

2104

---

How will you test a keyboard?

1094

---

Can QTP be used for GUI testing ?, We are using Java with MySQL and Operating system is Linux. We are NOT using the web.

2452

---

I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?

2321

---