ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question
how to retrieve the column headers in database using
vbscript statement in QTP
 Question Submitted By :: Sivakumar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how to retrieve the column headers in database using vbscript statement in QTP
Answer
# 1
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 ?    0 Yes 0 No
Akothuru
[Fujitsu]
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
I install .Net Add-Ins in my system. It installed properly. But all the objects are recognizing as window objects only. But it has to recognize as swf objects. In Record and Run setting i selected 'Record and run test on any open browser' and Record and run test on any open Windows-based application' Can any one tell what setting i have to do to recognize objects correctly as swf...? Please give some suggestions..?  1
how will we run batch tests in qtp what is the process to run the multiple test sets?  3
Hi every body, I am new to QTP.pls help me if anybody knows the solution. Here is my doubt: I have 3 excel sheets in my local drive out of which one is password protected and i want to get the data of all these xL's either by importing or by reading the data finally i have to update this data in the website.(and the site is secured site) I tried by importing all XL"s one by one but couldn't do so. plss send me the code or atleast suggest me the approach. Thanks in Advance Padmaja  2
While scripting do we use any reference. may be we have 2 0r more same objects that time how do we write scripts  2
How QTP recognizes Objects in AUT? Blue-Star3
What is test object model in QTP ?  3
hi i want write code for "test engineer" in this i want write reverse how ca plz let me know through script  4
What is InStr() Kanbay3
Suppose i have a script which is having 100 lines.I want to execute that script starting from line no 75.means first qtp should read the script from line no 75 how can u do it. Lehman-Brothers5
i have 2 year experience in manual and automation testing, I have less percentages in X, Xii (Second grade), can i elgible to TCS interview (Or MNC's)  2
What are the advantages of Automation objects than Test Objects? Adobe1
After geting the modules where we generate the script ie in qtp or notpad ?  1
HI, Anybody can explain Automation Test Framework...and wht do we do before start of Automation..... Siemens1
Hi! Using Descriptive Programming How do we get Parent object for an object. Say, i want to get a parent object for a "Link" in a web page. thanks  3
in qtp how can we do test when the build is not ready Mindlance2
HOW to invoke any recorded script in QTP with out using RECORD & PLAYBACK CONCEPT?  1
HoW to open QTP in Real time.after getting the qtp window how to log in .pl answer real time people GE3
Why u don’t like recording the script and writing the script Wipro1
does test plan is in test strategy or test strategy is in test plan. TCS5
Can we use same virtual objects in many number of tests? TCS1
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com