how to retrieve data from
flight resevation->reports
Answer Posted / manjunathareddy
Set oExcel=CreateObject("Excel.Application")
oExcel.Visible=True
Set oBook=oExcel.Workbooks.Add
Set oSheet=oBook.Worksheets(1)
Set Con=CreateObject("ADODB.Connection")
Con.Open("QT_Flight32")
Set RsObj=Con.Execute("Select * From Orders")
total=RsObj.Fields.Count
Do until RsObj.EOF
j=j+1
For i=1 to total - 1
oSheet.Cells(j,i+1).Value=RsObj.Fields(i).Value
Next
RsObj.MoveNext
Loop
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is synchronization? What are the ways you can synchronize?
How many types of recording modes in qtp? Which will be used when?
Functions call by reference and call by value. i want the diff b/n these 2 and how will be the script for this?in which situation we use these 2..?pls explain me clearly
HOW AUTOMATE TEST SCRIPT ? what time it will do? after gneration of basic script or Any , Plz explain detailed?
can i compare two databases using QTP ?
in data driven testing for performing operations which method is easy from manual test data,keyword view,or from database.and why?
Explain the types of object repositorys in qtp?
Give me At Least 5 Differences between DOCUMENTATION OBJECT MODEL(DOM)and COMPONENT OBJECT MODEL(COM)? Interviewer said me to WRITE the difference only in points not as you WRITE a paragraph ???? only in points
Explain the concept of how quicktest professional identifies object?
What are output values and why they are used ?
Hai anyone please "Explain about Framework in QTP?"
Explain the types of object repository?
In Remote acess server how u run a test?
How will you declare a variable in qtp?
Write a QTP script to enter a keyword in to Google search engine?