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
Hello friends..... On which areas of an application we can not test with QTP
How to handle the exceptions using recovery secnario manager in quicktest professional?
what and how to answer for the question "tell me about yourself ?" for 3 years experience. can anyone say inj detail please... its urgent
I want to configure the OR and library files to a particular QTP test during run time. Note: OR and Library files are located in Quality Center. Is it possible in QTP? Anybody having code?
When Recovery scenario actually starts while testing the application?
I am Facing Issues with learing datepicker 1)when i first learn datepicker as current system date . 2)if i wanna runtime datepicker value it gives error
can i change the runtime properties of an object ? How can i check if a parameter exists in database ?
Hi All, we are using QTP Automation Scripts to test SAP. I recorded QTP Automation Scripts in English-based SAP GUI. Now we have to test a French-based SAP sytem and use the same scripts. The QTP scripts are failing when executed on the French-based SAP System due to Object Recognition Issues. What can we do? Do I re-record the scripts in the French-based SAP system?
What is the expert view?
How to connect to a database?
What is qtpro? What is a quick test professional?
Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?
How you are developing the script? Using record and play back or manual?
In QA Testing when do you use Loadrunner vs QTP? What are the main differences between those two tools? Explain the purpose with real world scenario examples...In advance thank you!!!
How to handle Java tree in QTP?