Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the column headers in database using
vbscript statement in QTP
- 1 Answers
- 14992 Views
- I also Faced
- E-Mail Answers
VB Script Code to retrieve all column names
var_ConnectionString = "" 'specify the connection string
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open var_ConnectionString
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
msgbox colname
Next
| Is This Answer Correct ? | 8 Yes | 3 No |
If the weblist is identified as webelement,and by clicking on webelement if the values are displayed,and if the values the values also identified as webelement.then how to fetch the values through script?
wt is the difference between global and action excel database in qtp?for example one action is calling another action the second action is using action excell sheet?if it is using global sheet what makes the difference?
What is the QTP test frame work?
How do you invoke an application using the step generator in qtp?
Describe the process for writing text check point for a web application?
Wt is the difference between Business Component and scripted component?
If i entered 2 columns and 4 rows inputs in DDT Like Mango fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q is How to get the 2nd column value for corresponding 1 column input in 3rd row ie, ( i need to get "veget" in messge box @ run time
where we save the scripts created in one project?
When I click on a link in web page.Link should open in new window.can anyone please let me know the script for this ---Koti
what is database check point, how will you parameterize the database from seperate data table?
How to use reporter.report event in qtp ?
How can get count of list box?
WinRunner 
