Interested to Buy Any Domain ? << Click Here >> for more details...
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
Is it possible to split an action? How?
explain how to write vb script in qtp?when will you write own script?
What are the various automation frameworks available in qtp?
Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?
If I give some thousand tests to execute in two days what do you do?
Is any limitation to xml checkpoints?
What are parameterizing tests?
Can any one explain me what is the procedure to connect the remote desk by using QTP 9.2 ?
hi i have 4 yrs exp in manual and automation testing using QTP i need sample resumes plz can u send this mail id pbre1980@gmail.com
hi all can any body explain how to write the script for finding the mandatory fields which are having [red Astrik sign (*)]
1 Folders in VSS 2 In navigation script there are 100 script i want to run first 50 and 37th script also not needed to run how to do this 3 What is navigation script,Driver script, business script what we are loaded in this script 4 use of resource tab 5 Difference between verification and validation give real scenario example 6 file scripting object when to use it 7 what are the problems you are faced while testing web application 8 difference between expert view and keyword view 9 difference between QTP 8.2 and QTP 9.2 navigation frame work please answer these questions from real time working people as early as possible
Can the user toggle between using Local OR and shared OR for the same action?
What is CMMP and CMMH?
Pls can anyone give me the entire code for the Keyword driven framework with respect to he Flight Reservation Window in detail with explanation. Pls explain in detail stepwise. Thanks a lot. Pls very urgent?.
How qtp recognizes the object?
