Answer Posted / 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
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is expert view and keyword view?
What is qtpro?
Hi How to retrieve data from web element line by line?
What environment does qtp run in?
How to use the object spy in quicktest professional (qtp) 8.0 version?
Have you faced any problems with object repository?
How can you write the scripts that operate on different objects depending on run-time information?
Which scripting language used by quicktest professional?
what type of automation is follwed in the project?
Write the code for,In the page screen we have total 10 Links,out of these I have to click 9th link
What are the advantages of a Hybrid framework?
any body can you help me what is the script to automate an comand promt
What is text check point and text area check point?
How to use output values in qtp ?
How can i check items sorted or not in a weblist ? Give me the script for this...