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
Where is the Bitmap checkpoint information stored?
• What type of testing questions will be asked for 2+ yrs exp people in interview?
Can any give an example(if possible templates) how to test web application using QTP. thanks in advance
I want to open a Notepad window without recording a test and I do not want to use System utility Run command as well. How do I do this?
1--How many functions u develop 2--What is an array 3-- where is ur server 4--U involved in unit testing 5--how ur test the background colour using QTP
i am looking job in perfomance testing using Loadrunner any one help me a project plz......?(Chandana) chs_29@rediffmail.com
How do you send email with attachment from outlook using qtp ?
Should have experience in framework means?
How do we analyze the checkpoint results?
Explain qtp(quick test professional)?
How can i check items sorted or not in a weblist ? Give me the script for this...
Can we create a qtp test from qc?
How can we conduct U-I Testing by using QTP??????
I am getting the "test object property" Description properties "toolkit class" value By using "gettoproperty" in run time But my problem is how to get Ordinal Identyfier's type and value Type is index, value is 0 How can i keep this values in to required place How can i get these values in runtime I have to insert these "index" and "value" into another area Is there any script for this like "gettoproperties","Getroproperties" If anybody knows,please help me .
can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process