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 file database?
we add library file used in test via settings or through "ExecuteFile" command. when we implement framework do we make common library file and load the same for all the test cases execution?
Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?
Tell me one scenario, the complex functionality you have automated in your project?
can any body plz help by sending the qtp docs and qtp ppt's? this is my mail id:murali.padeti@gmail.com
what is run-time data?
What is the use of sendkeys and what are send keys
What are the different types of action?
What is the syntax to call one script from another? And what can be the syntax to call one “action” in another?
I want to test my vb.net solution file using qtp. Does Qtp test only .exe file?
what is the difference between the modular framework and datadriven frame work
What is QTP and the use of QTP in TD?
can any one please tell me which is the best institute in Bangalore to learn QA (crash course)? Thanks
i am a begnner so am learning Error handling :tried using Recovery manager didnt work i want to be able to handle errors , e.g. if while running the test the folwoing does not show up then how can i use the If then else and goto next step in the test, as in many scenarios it does not show up Browser("The Shopping Channel -").Page("The Shopping Channel -_8").Image("easy pay").Click
Explain building blocks of the bpt framework ?