QTP Bibliography

There's a list of very good websites where you'll find a lot of interesting and useful articles about QTP:

here are the resource used by me mostly:
http://www.learnqtp.com/
http://www.scribd.com/document_collections/2472259
http://www.guru99.com/quick-test-profess...al-34.html
http://www.sqaforums.com/ubbthreads.php
http://www.advancedqtp.com/forums/
http://forum.onestoptesting.com/default.asp
http://motevich.blogspot.com/
http://mercuryquicktestprofessional.blogspot.com/
http://en.wikipedia.org/wiki/HP_QuickTest_Professional
http://knol.google.com/k/collection-of-qtp-links#
http://knol.google.com/k/quick-test-prof...tion-tool#
http://www.open2test.org/techdocs.html

Check an alert dialog box and the text from it

In this post I will try to describe step by step how to create a function which checks for a dialog box and will also click on the button within it:

  Firstly we will create a class which we'll be calling on our need:

' creating the generic function
Public Function DialogBox
Set DialogBox = New QTPDialogBox
End Function


' defining the class
Class QTPDialogBox
Public Function CheckDialogBox (obj_DialogWindowId, obj_DialogWindowStyle, obj_StaticWindowId, obj_StaticText)
' defining the Dialog object's properties
Set obj_Dialog = Description.Create  
obj_Dialog ("micclass").value = "Dialog"
obj_Dialog ("nativeclass").value = "#32770"
obj_Dialog ("text").value= "Microsoft Internet Explorer"
obj_Dialog ("window id").value= obj_DialogWindowId
obj_Dialog ("windowstyle").value= obj_DialogWindowStyle

Set a DataBase connection and run any queries from QTP

How to set a DB connection and to get a value from an "adodb" Data Base

Public Function DBSelect

set conn = createobject("adodb.connection")

conn.open "DSN=DSN_SERVERhere; UserID=userID; Password=password;"

set rs = createobject("adodb.recordset")

'get the date value from DB for an Event

rs.open "SELECT searchColumnHere FROM tableName WHERE columnName='value'", conn

eventsInDB = rs("searchColumnHere")

'eventsInDB = FormatNumber(eventsInDB, 2) - use this if you need to format the output nr

rs.close

DBSelect = eventsInDB 'here we are defining the output value

End Function

Create a function which returns a random number

How to set a "randomValue" to a variable and How to run an UPDATE within a Data Base using this variable
'set a random number - this function will be called to do updates
Function RandomNr
upperbound = 1000-1
lowerbound = i
For i=1 to upperbound
Randomize
RndNr = Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
Next
RandomNr = RndNr
End Function

Descriptive Programming

In this post we'll discuss about:

Introduction to Descriptive Programming.
How to write Descriptive Programming?When and Where to use Descriptive programming?
Some points to note with Descriptive Programming.

Introduction to Descriptive Programming:Descriptive programming is used when we want to perform an operation on an object that is not present in the object repository. There can be various valid reason to do so. We will discuss them later in this article.