What are the details steps to connect a remote mysql
database in QTP
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
Hi! Using Descriptive Programming How do we get Parent object for an object by writing script(DP). Say, i want to get a parent object for a "Link" in a web page by writing script in Descriptive Programming.
Define virtual object?
When Recovery scenario actually starts while testing the application?
What are test settings and global settings?
Explain the features of quick test pro(qtp)?
How to analyzing test results using quicktest professional?
How did you resolve conflicts present in Object Repository?
How to remove the associated function library?
What is a checkpoint? How many check points are there in qtp?
Hi. I have completed B.TECH(CS) , But I will go to "SECURITY CONSOLE OPERATING" [C.C CAMERA abservation]. IF interviwer asks " Why you choose this job ?" What we will say? urgent.........................urgent...........
To which environments does quicktest professional (qtp) supports?
How often were they executed?
Which scripting language used by quicktest professional (qtp)?
How you are developing the script? Using record and play back or manual?
How can i initiate the objects to find uniquely in OR