How to connect MS Access using QTP scripts

How to connect MS Access using QTP scripts and display results

Dim connectionMS, recordsetMS

Set connectionMS = createobject(“adodb.connection”)
Set recordsetMS =createobject(“adodb.recordset”)

connectionMS.provider= “microsoft.jet.oledb.4.0”

connectionMS.open “C:\yourdatabase.mdb”
recordsetMS.open “select * from YourtableName”,connectionMS

databaseValue = recordsetMS.fields.item(0)
msgbox databaseValue

Set connectionMS = nothing
Set recordsetMS = nothing

QTP program to display odd and even numbers

QTP program to display odd and even numbers

‘ program to display odd numbers 

Dim OddNum,  o

o = Inputbox(“enter any value to check list of odd numbers in it”)

For OddNum = 1 To o Step 2

print OddNum

Next

‘ program to display even numbers 

Dim  EvenNum,  e

e = Inputbox(“enter any value to check list of even numbers in it”)

For EvenNum = 2 To e Step 2

print EvenNum

Next

19 regular expression methods in UFT/QTP

19 regular expression methods in UFT/QTP

1.       Period (.) is used to represent or replace any symbol except new line

2.       Asterisk (*) represents zero or more occurrences

3.       Caret (^) sign instructs beginning of the line

4.       Dollar ($) sign instructs end of line

5.       \b instructs Word boundary

6.       ? instructs zero or more occurrences

7.       + instructs one or more occurrences

8.       {} represents exact number of occurrences

9.       []  represents any character in the set

10.   [^]  represents any character NOT in the set

11.   () represents Group

12.   I represents Or

13.   \n represents new line

14.   \W represents any non-Word character

15.   \d is any digit

16.   \D is any non-digit

17.   \s is any white space character

18.   \S is any non- white space character

19.   \ is escape special character

How to setup Recovery scenarios in QTP/UFT

How to setup Recovery scenarios in QTP/UFT

To handle unexpected errors, popup etc , QTP/UFT uses this feature (also when existing code is not designed to handle this issue)

1.       Navigate to Resources > Recovery Scenario Manager

1 Recovery scenarios manager
1 Recovery scenarios manager

2.       Click on below marked icon. Select the trigger (here is Pop up window)

2 Recovery scenarios trigger
2 Recovery scenarios trigger

3.       Now record the trigger – if required Regular expression can be added. It will add window title automatically.

3 Recovery scenarios trigger config
3 Recovery scenarios trigger config

4.       Now select the recovery operation.

4 Recovery scenarios trigger operation
4 Recovery scenarios trigger operation

5.       After recovery operation go to post recovery operation as copied below

5 post Recovery scenarios
5 post Recovery scenarios

How to do smart identification in QTP

How to do smart identification in QTP

Smart identification is needed when recorded script fails to recognize the application object (it may be due to multiple objects has same properties/values or recorded property value is changed)

Smart identification uses additional 2 set of object identification layers (1. Base filter properties 2. Optional filter properties) apart from regular mandatory, assistive properties.

1.       To get smart identification enabled – navigate Tools > Object identification.

1 object identification
1 object identification

2.       On object identification window – click on configure to add 1. Base filter properties 2. Optional filter properties as shown below.

2 object identification properties
2 object identification properties

How to do parameterization in HP UFT/QTP

Parameterization is used to replace the hard coded recorded values in the code.

How to do parameterization in HP UFT/QTP

1. Record the script and find out the values that you want to parameterize it.

2. Refer below – user login id is intended to parameterize here.

3. Click on View > Keyword View

keyword view
keyword view

4. Will bring the below screen and click the value field (marked in green below)

keyword edit
keyword edit

5. should bring below screen

keyword edit table
keyword edit table

6. Select parameter and give a meaningful name as below

keyword parameter
keyword parameter

7. click ok

keyword parameter ok
keyword parameter ok

8. now go back to Editor

qtp editor view
qtp editor view

9. as you see below, original code is updated with parameterization and you could see the script execution window updating the application under test (gmail.com) is updated with the parameterized value.

qtp source code
qtp source code

 

 

10. QTP results viewer is updated with parameterized values

qtp results

qtp results

connecting qtp to qc, step by step.

connecting qtp to qc, step by step.

connecting qtp with qc. How to connect qtp with QC where QC stored all the QTP scripts.

1) Open QTP and navigate to  ALM Connection

HP UFT_1
2) Fill the QC/ALM URL, User id , password and click on Connect
HP ALM_2
3) Once it is connected, HP ALM connection window will show as below.
HP ALM_3

 

hello world first java program

hello world first java program

Creating first Java project

  1.  first you need to install Eclipse IDE – can be downloaded from https://www.eclipse.org

Eclipse will look like below,

2) create a project using Eclipse IDE, and give name as “Hello world”

Java project

3) create a package as shown below

Java Package

4) create a class as below,

Java class

5) fill the package name and class name as below,

Class creation

6) now insert/write the following program , since by default package and class name appears int the code

public static void main (String [] args)
{

System.out.println(“Hellow world………………. “);
System.out.println(“this is my first progrm”);

}

now you see the package name and class name are matching with the left pan tree structure as per below email. Also notice when you execute the results are displayed below.

Java - Hello world