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

How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s.

0 Answers  

---

What is the Diff between Image check-point and Bit map Check point?

15 Answers   CTS,

---

I Have web table shown below ----------------------------------------| | orcut | GMAIL | NAUKRI | |----------|---------|-------------------| |HOT MAIL | MONSTER | VISIT FACEBOOK | |----------|---------|-------------------| |SKYPE ACC | IRCTC | GOOGLE | --------------------------------------- Here i have 2 question friends.. 1.i want to chick the link "VISIT FACEBOOK" is there or not if it's there i want to click the link 2.here how to find the web table row or column count ... don't write the excel or data table script here friends ..consider that it's a WEB TABLE

3 Answers   HCL,

---

Hi All, issue is related to handling pop up script generated in IE, and run on mozilla. In App Under Test, when we get the alert pop ups, we just click ok button. if we need to run the same code on mozilla it will not identify . so we will check browser if browser(*).dialog(IE object).exits browser(*).dialog(IE object).winbutton(OK).click else 'by default mozilla browser(*).dialog(mozilla object).page(*).webbutton(OK).CLICK END IF But my qustion is. Do we write the above piece of code where ever we get such kind of pop ups from the application like alert pop up, confirmation pop up.... OR do we have any other alternative way to do this by using any functions in Recovery Scebarios? If Any of u know idea please do help me in this regard. or send answer to kravimb@gmail.com

0 Answers  

---

How often were they executed?

0 Answers   Sarga Technologies,

---

---

What is difference between Recording time object identification and Run time (Execution) time.

0 Answers   Tech Mahindra,

---

what is run-time object property in Object spy in QTP9?

3 Answers  

---

can a Function return more than one value..??? if so please give me the code for that.

5 Answers   DST Global Solutions,

---

Hi guys pls any one send me the Qtp Licensed key of version 10.0 pls

0 Answers  

---

What are the data types in qtp?

0 Answers  

---

In qtp, how you can remove the spaces from string?

0 Answers  

---

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 .

0 Answers   Livetek,

---