What are the details steps to connect a remote mysql
database in QTP
- 1 Answers
- 5639 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / santhosh ankam
This is code to run sql query through qtp.
SQL "SELECT * FROM ORDERS"
connection_string "QT_Flight32"
columns 1
set connection CreateObject("ADODB.Connection")
connection.Open connection_string
set rs1 connection.Execute( SQL )
rows db_get_rows_count(rs1)
msgbox rows
rows rows-1
myval db_get_field_value(rs1 rows columns )
msgbox myval
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
How many test scenarios you have automated? How many time it will take to execute 30-40 scenarios? What SDLC model you are following? How often you will execute your test scripts? Because of some changes, your test scripts failed? When you will update your test scripts? How much time it will take to update? Do you know how to connect database? Do you know the direct method to count no. of records (or) rows present in record set once query is executed? How will you create the connection string? How did you resolve conflicts present in Object Repository? How good you are in VB? How will you work on Excel Application? How will you select Excel sheet? If you want to select 10 sheets, will you create 10 separate objects? Given string is “abcd”. What are the methods you will use to display “dcba”? Drives script – explain the frameworks? How you are updating results for each test? What is start up, configuration, navigation scripts? If you are not able to understand the application (some module), who will teach you? What test cases to be automated? When to be automated? What is the testing process you are following? What life cycle you are following? When you will use Descriptive Programming? Do you have the permission to add objects into shared object repository? (OR) someone will maintain SOR? Do you know how to add objects into shared object repository? How many test cases you have automated? How much time will it take to execute? What is complex in automation? When you feel automation is complex? Tell me one scenario, the complex functionality you have automated in your project? Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet. Rate yourself in SQL? Display the employee name who is getting maximum salary? sal ID Salary name 001 100 002 500 003 300 ID 001 002 003 Ename A B C Have you written any test cases while you are in Automation? Manual Testing also will you do or you will work only in automation?
what type of automation is follwed in the project?
hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.
In qtp, how you can remove the spaces from string?
What are the types of object repositories? Which one is you are using?
Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.
Hi.. I want to do parametrization for selecting perticular flighr say XYZ by using local table: criteria: 1.If flight is available msgbox "Flight is available" and then select flight from flight table and click to ok button after that as enter username and ticket no and then stop 2. otherwise msgbox " Flight is not available" and stop Please help me out ..and let me know your responses on dipak.bachhav@gmail.com Regard, Dipak
What are the types of object repository in qtp?
how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page
how to i add the values using the check points property?( i.e valid data(for valid data it's giving the footer message:value is added) and for invalid data: special chars, spaces,Duplicates and null values (in my page when ever we enter special chars, spaces and null values, it's giving the proper warning message and for Duplicates it's giving the footer message:"value already exists)?
How are actions and functions different in QTP?
How should I click on the right click menu objects When I trying to add the object properties to the OR.It is showing only Window(Window).Not all the objects of the window. Also while recording I found No script. How to solve this>.
Explain the concept of object repository and how qtp recognises objects?
How to analyzing test results using quicktest professional?
What is the syntax to call one action in another?
