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

I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?

0 Answers  

---

How can we check whether a particular sheet loaded (existed) or not in Data Table.

7 Answers   TCS,

---

WAT IS DATA BASE AND XML CHECK POINT ?HOW TO IMPLEMENT IT ... GIVE PROPER EXAMPLE FOR IT

0 Answers   Infosys,

---

How to use checkpoints in qtp ?

0 Answers  

---

hi all i have qtp 9.0, Active screen is not working means after recording script snap shots not displayed in Active screen window. i have all ready check all setting means Tool...>option...>Active screen...>Default Level button is disabled. Is there other setting is remain to set Pls help i m new for qtp

1 Answers  

---

what is the Command used to start the QTp from Run.(start-> Run)

7 Answers   GE,

---

I want to know what are QTP functons and what are VB script functions. What is the difference between them.When we have to use these functions.

0 Answers  

---

how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance

0 Answers   Synergy,

---

Hi, I am using 2 excel sheet.First excel sheet works fine with the script, if it opens the 2nd excel sheet,it works fine,but after finish all the rows it is giving the following error in the following line. InValid Procedure call or argument Line (178): "Browser("name:="&result,"application version:=internet explorer 7").Page ("title:=bgt.*", "index:=0").WebList ("name:=SearchType","html id:=Select1","location:=0").Select SearchType1". I have seen a web article says that,If we use any vbscript friendly name it may gives the above error-Invalid procedure call or argument not sure,Am I using any VBScript frienlyName? in the above line? [but the same line is perfecly working for first Excel ] It is little urgent. Any Help Thanks you

0 Answers  

---

If an application name changes frequently i.e while recording it has the name, in this case, how do qtp handles?

0 Answers  

---

what is the test process followed for your project?

1 Answers   ADP, Satyam,

---

write script for how to add function library in QTP

2 Answers   Aspire,

---