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 ?    1 Yes 0 No
Akothuru
[Fujitsu]
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
What is API?  1
How we can capture the dynamic object ex:(rotating globe) in the web page with time gaph is 5 sec.. IBM2
how u write vb script in qtp pls give me some basic script and some material Datamatics22
How can I test the unix shell in QTP Persistent1
Hai anyone please "Explain about Framework in QTP?"  5
What is the BPT(bussiness process testing ).and what is the main difference between BPT and QTP EDS2
HOW to invoke any recorded script in QTP with out using RECORD & PLAYBACK CONCEPT? CTS2
Use of Debug Viewer?  1
Hi Friends... What you are doing in Regression Testing and how many test cases you ran in regression testing... suppose there is 1000 test cases is there how many test cases again you run .. 1000 test caes r how many... thanx in advance..  6
Could some one help me the difference between GetTOProperty and SetTOProperty and when we will use these properties. and what is meant by SetToProperties.. Clinical-Soft5
DIFFERENT RUN MODE IN QTP..1-VERIFY MODE 2-UPDATE MODE 3- dEBUG MODE. My question is in whic sitution we use these modes Explain me with example  1
How to get line numbers in your editor in expert view?  1
how open two urls in one browser? plz urgent Satyam5
tell me about framework types and most used framework in real time. types of output value in details. diff between wr and qtp in detail.  2
how many test scripts we will write in qtp? very urgent. please??? Thanks in advance..  1
what is descriptive.create()in qtp? IBM2
how can we retrieve ten rows from the data table using loop concept?  3
CAN ANY ONE PLEASE EXPLAIN DIFFERENT TYPE OF FRAMEWORKS USED IN QTP?EXPLAIN EACH OF THEM?..POST TO VANILKUMAR_1981@YAHOO.CO.IN  1
in how many ways we can write the user defined functions one way i know that i.e storing it in .vbs another way i does not know my friend said that .qtf or something but start with q letter can any buddy knows about this DigiTech3
What is the need and applications of learning VB script for a automation(QTP) engineer ain Realtime ?  1
 
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