What are the details steps to connect a remote mysql
database in QTP
Answer / 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 |
How will you set a unique four digit number in an edit field in QTP?
QTP is not displaying in OBJECT SELECTION-CHECKPOINT PROPERTIES boxs only WINDOW AND WIN OBJECT remaining pages and links , images not displaying in web application testing. how can I get the pages and links in object selection? Please anyone tell me?
How to data driven test for Win objects in QTP ?
any body want to learn qtp with real time concept on Banking domain contact ciraaj@gmail.com
hi, i am trying to capture "web element" names in a web page, and i written the code like this,, with Browser("title:=") with .page("") .webelement("htmltag:=...").getroproperty("innertext") end with end with //////////////////////////////////////////////////////////////////////////////////// QTP RETURN ERROR like this: " object's description matches more than one of the objects currently displayed in your application. Add additional properties to the object description in order to uniquely identify the object" ok fine , i need to search another property other than "index" i use all the properties like class,text,innerhtml,innertext,visible=true,x , y,abs x ,abs y...but qtp returns error ..... in this webpage index is difficult to find? how to solve
what are the main differences between keyword driven frame work and data driven frame work?
in a database table there are 3 columns (name , marks,grade) , in application after retrieving data from db to fields name, marks click ok button then grade should displayed ---for this how to write vb script prgm
Can we create test script with out Step Generator?
can we take 'dim my pen is good' as a paramerter
if there r 10 windows open in QTP write a command to close all 10 windows at a time ?
Explain Different types of Checkpoints in Quick Test Professional?
Can anybody help me by sharing the code for checkbox in qtp using vbscript.