Answer / jayadev acharam

Using ADODB Object
Example
DB_Connect=CreateObject(ADODB.Connection)

Answer / akshay

Public Function database(Str,SQLstr,outResult1,outResult2)

'//Variable Declarations
Dim objConn, rsOut

'//Create a connection object.
Set objConn = CreateObject("ADODB.Connection")

'//Create a ResultSet Object to store the results.
Set rsOut = CreateObject("ADODB.Recordset")

'//Open the Created Connection object
objConn.Open Str

'//Pass the SQL query string and retrieve the Results
through the connection object
rsOut.Open SQLstr,objConn

If rsOut.EOF <> True AND rsOut.BOF <> True Then

'//Store the different column values
retrieved from a record in different variables.
outResult1=rsOut("col1")

outResult2=rsOut("col2")

rsOut.movenext
End If

End Function

what is the syntax for regular expression in QTP? how to create user defined functions in QTP?

6 Answers   CTS, MBT, TCS,

---

What are the major/ important methods, functions in QTP we use realtime testing

0 Answers  

---

Give me an example where you have used a COM interface in your QTP project?

1 Answers  

---

Hi all Can u give me the link where we can download full version of qtp my mail id is karthic.venkitapathi@gmail.com

0 Answers  

---

How software tester can use constants and variables in scripts?

0 Answers  

---

Hi. GetRoProperty and OUTPUT Value Both are same purpose or not? plz explain in deatil with example?

5 Answers  

---

After i ran the Test in Batch mode i didn't get any results. Can any one let me know how it can be done?

3 Answers  

---

Why do we use breakpoints in QTP?

0 Answers  

---

Is it possible to run qtp scripts in Test Director(Scripts are uploaded in Test director)???and also how to see the test results in test director???

1 Answers  

---

How can I change object description or check point values in qtp?

0 Answers  

---

what are the difference between qtp8.2 to 9.0 surya

1 Answers   Bally Technologies,

---

What is our exact stage involvement with QTP?

1 Answers  

---