What are the details steps to connect a remote mysql
database in QTP
- 1 Answers
- 5489 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
Hi, Can anyone please tell me how to connect the QC with QTP using QTP script? Thanks in advance
what is clean sweep?
In application which areas to be automated and what kind of situation will be take? using QTP? Plz give me the clear answer
Which scripting language used by quicktest professional?
What are the different properties of an web object
How can you give wait up to 10 seconds in qtp?
can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?
what type of values given to objects. EX::Set oBrowser=Description.Create oBrowser(“micclass”).Value=”Browser”
what is clean sweep?
What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????
I need to obtain the parent of an object programatically, so if I have: winButton("aButton") I need to obtain the parent part: window("Window1").Dialog("Dialog1") so I can programatically create a string of the full name of the object to call it with an execute statement in QTP I would like to use something like: part[1] = "window(""Window1"")" part[2] = "dialog(""Dialog1"")" so I can do: exeLine = part[1]&"."&part[2]&"."&"winButton(""aButton"")" Execute exeLine Apart from keeping a record of the window/dialog hierarchy is there a parent or path function/ command Thanks Adrian
How to use transactions in qtp?
When do go for loop condition in test?
How did you resolve conflicts present in Object Repository?
How to connect to a database?
