write progamming connecting QTP to database sql? this is
question asked by interview? please give sql, pl/sql related
answer?pls any answer this?

Answer Posted / bharanikumar . r

Hi all,

I had some idea about this question

Answer:

First we need to create the object for connection

ie.
Set a = Createobject("ADODB.Connection")
set b = Createobject("ADODB.recordset")

Then with the help of created object we will define the SQL
Query

For ex:
Opening the data from SQL:

step 1 - create the connectivity whether manually or qtp
step 2 - a = Select * from exmployee with the connectivity
with DSN

and we have to declare the array size also because once a
data retrieved from the database it will stored in array
format --

Thank u

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you do batch testing in wr and is it possible to do in qtp, if so explain?

508


how to disable the pop ups through QTP using a script

1730


How is a Step generator used in UFT?

661


The hybrid framework can be implemented for any application. Is it true?

589


when u script reveiwing in which area u more concentrates?

1418






Explain sub procedure of vbscript.

590


What are the types of object repository?

582


when to start the automation?

1478


Why do we use breakpoints in QTP?

582


hi i want license key for qtp 9.2 pls its adjust product name : quick test professional locking code :8 - 54A6A license type : seat license maintenance number : 88888888-8888 pls send license key to my email id borusu.ramkumar@gmail.com

3703


Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??

1636


Explain different recording modes?

585


what you mean by artifact,milestone...

1498


I used child objects to get the no of weblist present in the weblist.now i need to select the items present in each weblist ?How to do so

2256


how can we test the Triggers, Cursors, Indexes while doing Database testing in DTP??

1588