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
We stored into the objects OR and then write the scripting
How to handle the exceptions using recovery secnario manager in quicktest professional (qtp)?
Suppose you are using shared objects repository in your test and you want to split your present action? At that time shared object repository is single or it’s also splits?
Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..
When I click on a link in web page.Link should open in new window.can anyone please let me know the script for this ---Koti
In qtp, how you can use xpath to identify objects?
What is throw object?
How can get count of list box?
Explain in brief about the quicktest professional automation object model?
How is UFT 11.5 version different from UFT 12.0?
How to do call a output parameter from one action to another action??/
What processes will be required to manage updates to the web site's content, and what are the requirements for maintaining, tracking, and controlling page content, graphics, links, etc.?
Whether qtp 9.0 supports Test director8.0
How to get the particular property value?
How to find the name of the machine where you are running your automation scripts in qtp?