Interested to Buy Any Domain ? << Click Here >> for more details...
What are the details steps to connect a remote mysql
database in QTP
- 1 Answers
- 6256 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
I have created 3 actions in test action1, action2, action3 but I want run action 1,action 3,action2 how can you change in the actions in keyword view?
can u please explain what is the exact difference between qtp8.2 and 9.0
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object.. (give a filter condition only WEbelement- not easy need to use some more property while giving filter condtions- use google for your help...))
Give me At Least 5 Differences between DOCUMENTATION OBJECT MODEL(DOM)and COMPONENT OBJECT MODEL(COM)? Interviewer said me to WRITE the difference only in points not as you WRITE a paragraph ???? only in points
What are the technics follow in writing VB script?
how to know no.of mails in our g mail by using vb-script
How reliable are the site's Internet connections required to be? And how does that affect backup system or redundant connection requirements and testing?
what type of automation is follwed in the project?
In an interview, what r the general questions asked in SQL which is realted to testing ?pls give me anwser to this question?
Brief the process of testing with UFT?
Explain the concept of object repository and how quicktest professional recognises objects?
What is throw object?
How you will rate urself in QTP in the range of 0 to 5
Can any one brief some detail on how the shared and action object repository utilized/implemented in a real time project. I already know how to make shared object repositor by saving OR as .tsr extension..I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thanks
What are the various automation frameworks available in qtp?
