Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve data from
flight resevation->reports
- 2 Answers
- 5017 Views
- Wipro, I also Faced
- E-Mail Answers
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
when I try to run below script in QTP "totalPages" value is 2. But i am getting error message (Type mismatch: 'totalPages' Line (): "For i=1 to totalPages".) totalPages=Browser("Name:=User").Page("Title:=User").WebElem ent("innertext:=of.*").GetROProperty("InnerText") msgbox totalPages For i=1 to totalPages rnum=Browser("Name:=User").Page("Title:=User").WebTa ble("column names:=User Name;ID;Last Name;First Name").GetRowWithCellText("store4") If rnum>0 Then r=rnum Exit for End If Browser("Name:=User").Page("Title:=User").WebElement ("html tag:=A","x:=471").Click MsgBox "Exit" Next
Explain about business process component? types and usage?
Explain different types of checkpoints?
What are the features supported by UFT?
How can you handle exceptions in qtp?
What is the difference between a Function and Procedure in QTP?
What are the 3 main stages involved in testing with qtp?
How many types of recording modes in qtp? Describe each type with an example where we use them?
What is checkpoint in qtp?
How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet
I opened gmail login into gmail and i have to save (Pass or move) all the mail into notepad please give me code Thanks of all
How will you check that your test cases covered all the requirements?
How to analyzing test results using quicktest professional (qtp)?
Is it possible to call win runner script in qtp?
what is supply chain management?
