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
What is system testing and what are the different types of tests you perform in system testing?
What are the data types in qtp?
What are the main differences of qtp and win runner?
Mention the test steps of qtp.
Can anybody post some real time scenario in qtp? please its very urgent.
Explain the concept of object repository and how qtp recognises objects?
Explain the types of object repositorys in qtp?
How to build scripts that access data from external sources?
How QTP support all types of applications (platforms)?
what is impact analysis on regression testing?
How do you compare the structure of 2 tables in database and check whether they are similar using qtp.
There are 10 rows in the datatable. How can we fetch 2 rows and then skip 3rd row. After that, pick 4th & 5th row and skip 6th row. Please share code
Explain about the test fusion report of quicktest professional (qtp)?
Is it possible to refer the same object for referring more than one object that are of different class using the descriptive programming approach? Suppose my code is 'To create the object named as obj Set obj=Description.Create() 'To define the values obj("title").value="IE" obj("type").value="text" obj("html tag").value="INPUT" 'To set the value Browser("IE").Page("Yahoo").WebEdit(obj).Set "xyz" Can I refer the "obj" object for the three objects like Browser,page and webedit objects? If so how?
What is the Difference between copy to action and call to action?