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

How do you convert manual test cases to automated test cases?

0 Answers  

---

WHAT IS THE DESCRIPTIVE programming when it is useful? & when to use this ?

2 Answers  

---

Basically why we need testing?

14 Answers  

---

how to write the descriptive programming in QTP for loginwindow.without using Step generator,object repository for referecnes

4 Answers   STC,

---

how do u handle an object with out name in our application using QTP 9.2?

0 Answers   CTS,

---

How to export(copy) the entire webtable from the webpage into Excelsheet? using Vb scripting

9 Answers  

---

How to handle recovery scenario for a application crash.write script for this.

2 Answers   Polaris, TCS,

---

datatable.Import("E:\Programming Samples\QTP Samples\OrderNumbers.xls") Asume we have 4 records in datatable Code reads the 4 rows in the sheet ok, but does it 5 times? It doesn't sound like closing the datasheet is the problem Can we close the datasheet runtime ?

2 Answers  

---

how do find current links in webpage for ex: in yahoowebsite today mainpage is having 50 links and next day same page is having 60 links. if i run same programe it should display total links in webpage ?

4 Answers   CTS,

---

What is the syntax to use out of two characters. Pls anybody can give the answer.. Thanks in advance...

1 Answers   Navis,

---

regular expression

2 Answers   Wipro,

---

Tell me few important difference Between QTP and WinRunner?

9 Answers   TCS,

---