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
Where to use Property Let, Property Get, Property Set in UFT
I want to test my vb.net solution file using qtp. Does Qtp test only .exe file?
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?
one screen page,that contains file , browse , update and cancel buttons.when we browse a file it should get update otherwise it should go to previous page.write negative test case for that.
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?
What is difference between run time object and test object?
Explain different recording modes?
Hi, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?
Dear Friends, I having total 3+year experience in manual testing including automation testing QTP, if i am attending any interview what kind of question will i get? please help me out
How to remove associated function library?
Explain how you can replace string in qtp?
In qtp, explain what is qrs file?
Does QTP run in any environment?
Is QTP Supports SWT applications? If yes, can you write a sample script for opening a new package in eclipse.
Hi, While recording a Jave based web application, its recording all my actions and the objects.And I have 5 WebEdit objects on the page and all are recorded. But while execution, at the 2 WebEdit object, its entering the value into the object (Its making a call to the AJAX, matching the value), when the control get out of this object the value is erased or cleared. Could anyone please help. I have recoreded 5 more scenarios where WebEdit is in the picture on different webpages and all are working fine. Here is my Script: Browser("Sign In").Page("Matching Workbench_3").WebEdit ("locationLookup").Set "0320 - SEATTLE-KM" Browser("Sign In").Page("Matching Workbench_3").WebEdit ("supplierNameLookup").Set "TRAMMO PETROLEUM INC" *** SupplierNameLookup is the object, which is haing an issue. And also I was using the SendString function, but it didnt work.