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 the use of "New Property" in "Add properties" of testobject properties in object repository. How can i use "New properties" while writing scripts if i have assign some values to the testobject properties Can anyone help me? plz
unique properties of button,edit box, radio button,check box?
Suppose I want fail that check point? How can you do that?
How to associate shared object repository to test in qtp?
What are the Test design techniques you uses in ur project?
Problem with XML checkpoint in QTP ?
Hi Friendss..., can any body help me.. 1. Tell me your achievements(Technically)..? 2. Tell me your strengths(Technically) and weakness(Technical)..? 3. Why are you looking for change..?
how to post xml data from QTP scripts to any application?
How does qtp identify gui object?
Is there any relation between Keyword Driven Framework and Recording modes provided in QTP( whether Recording modes are applied on keyword driven framework or not?)
Explain the concept of how quicktest professional identifies object?
Can we use index on view?
supose i hv to acsess some functionlaties of a test in 1 machin , some part other machin how can acsess?
What is quick test pro? What is a quick test professional?
what could go wrong with test automation?