Answer / santhosh ankam

This is code to run sql query through qtp.

SQL "SELECT * FROM ORDERS"
connection_string "QT_Flight32"
columns 1
set connection CreateObject("ADODB.Connection")
connection.Open connection_string
set rs1 connection.Execute( SQL )
rows db_get_rows_count(rs1)
msgbox rows
rows rows-1
myval db_get_field_value(rs1 rows columns )
msgbox myval

Hi This is tanya actually im facing problem in Qtp actully some time QTP doesnot recoznise the recorded object due to which script is going to fail.so can you tell me how we can handle this situation and i have another concerened issue is that at the time of run New errors comes every time so how we can handle this sitauation how we can add Recovery scenarios to the script.some time application runs successfully and some time it produces new error thats why i am facing lot of problem please give me the sugeestion as soon as possible.

2 Answers  

---

can any one please tell me QTP 9.2 supports which version of IE and Mozilla firefox.

1 Answers  

---

I am not able to record yahoomail browser.its giving error like "The browser Application can't be launched .Posssibly the URL is wrong" So anyone can tell me what setting i have to do in qtp??

1 Answers  

---

What type of VB script u had done in expert view?

1 Answers   HCL,

---

What are the environment variables?

3 Answers  

---

How do we run a test from the 3rd row of the datatable in QTP? Leaving the first two rows we need to test AUT from 3rd row to n'th row.

3 Answers   Virtusa,

---

How can you connect the database with QTP?

3 Answers  

---

what is the diffrence between script and Language ? (Chandana)

6 Answers   Cognizant, Wipro,

---

what is the data driven testing?

0 Answers  

---

Can anyone explain about Keyword driven framework in detail and how to use it in case of any project

4 Answers  

---

What is quick test pro?

0 Answers  

---

how we connect oracle or sql data server database to qtp.

4 Answers   TCS,

---