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 can we do this one ? at runtime qtpwindow and browser aren't disply on monitor (or) aren't visible on desktop?how?

1 Answers  

---

keyword driven framework having how many folders? explain folders in detail?

1 Answers  

---

How to Test the mainframe application?(tell me few basic things)

3 Answers  

---

Gmail application is there.On that Inbox so many mails are there including naukari mails. On that mails i can select the only naukri mail checkboxes. plz tell the descriptive code for the above..

2 Answers   Impetus,

---

Limitations in QTP?

0 Answers   CIL,

---

Which object model is not supported by QTP? a)COM b)DECOM c)DOM d)DCOM. Pls explain about theese object models?

1 Answers  

---

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,

---

what is the difference between data table and spread sheet?

1 Answers  

---

What is Parameterizing Tests?

4 Answers  

---

descriptive program for a yahoo mail that is in yahoo mail suppose check box mailid subject assume it is like this format all things are in webtable the question is suppose some mail ids are there in that mailids i want to select the check box wich is before a@gmail.com and after that i want to click on delete button

0 Answers   DigiTech,

---

Can you tell me any books or websites to learn VB Script for QTP ??

1 Answers  

---

How to handle Dynamically changing Objects in QTP?

4 Answers  

---