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
How do you do batch testing in wr and is it possible to do in qtp, if so explain?
how to disable the pop ups through QTP using a script
How is a Step generator used in UFT?
The hybrid framework can be implemented for any application. Is it true?
when u script reveiwing in which area u more concentrates?
Explain sub procedure of vbscript.
What are the types of object repository?
when to start the automation?
Why do we use breakpoints in QTP?
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
Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??
Explain different recording modes?
what you mean by artifact,milestone...
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
how can we test the Triggers, Cursors, Indexes while doing Database testing in DTP??