how to retrieve the column headers in database using
vbscript statement in QTP
VB Script Code to retrieve all column names
var_ConnectionString = "" 'specify the connection string
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.RecordSet")
strSqlQuery = "select * from employee"
'Execute query and Store the results into Record set
objRecordSet.Open strSqlQuery, objConnection
For var_Loop = 0 To objRecordSet.Fields.Count - 1
colname = objRecordSet.Fields(var_Loop).Name 'column name
|Is This Answer Correct ?||8 Yes||3 No|
Hi All, Can anyone provide me the license for QTP 9.5.... My Email ID: firstname.lastname@example.org
I need diffrences between Object Identification, Smart Identification, Regular expresion,Low-Level Recording (enables you to record on any object in your application, whether or not QuickTest recognizes the specific object or the specific operation.) I am working on Web Application. In that object caption will change dynamically. For example, consider “Save” button. On clicking save button the caption changing as “ EDIT ”. From above concept which concept I have to use here?
Hi Friends, I'm new to QTP. I want to write a function in QTP for below senario. In an Excel sheet column B, I Have 10 Url/Links, and in Colum A there is a Flag as Y and N. My test should run only on those iterations which are flagged as Y. Please help, Thanks
Hi let me ask one questin 1.How to use outputof the one function input to the another function pls give the script for above 2.what is the purpose of action parameter , how to create it
write script for "dropdown button having how many words? for ex.SELECT CITY is dropdown name.. find out how many cities in that?
how to record a word doc using qtp i.e open a word doc,type something and save the doc can someone send me the code.
How to work with multiple browsers when opened in the window, write the script for it
How can you handle exceptions in qtp?
How i can use and create Library functions in QTP and what is the proces .
What is Object Spy in QTP?
Hi ,Can any one pleas explain how to test splash objects using QTP?