Blog to understand automation concepts in QTP, Selenium Webdriver and Manual Testing concepts
How to Export/Import tests in QTP
Labels:
Advanced QTP
How to compare arrays after sort data in Array using VBScript in QTP
Labels:
qtp Scripts,
VBScript
In this article, we will discuss how to work with arrays explaining the below concepts:
- How to sort data in the array.
- How to compare two arrays.
- How to view elements in an array
'''''''''''''''''''''''''''''''''''''''''''''''''Test Data for the example''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
arrayDataA = Array(43,54,65,76,87)
arrayDataB = Array(87,65,54,43,7)
'''''''''''''''''''''''''''''''''''''''''''''''''Calling the functions for arrays''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
call funcArrayComparision(arrayDataA, arrayDataB)
arrayData = sortArray(arrayDataA)
ViewsortArray(arrayDataA)
'''''''''''''''''''''''''''''''''''''''''''''''''Function to sort data in an array'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
public function sortArray(arrayData)
For i = LBound(arrayData) to UBound(arrayData)
For j = LBound(arrayData) to UBound(arrayData)
If j <> UBound(arrayData) Then
If arrayData(j) > arrayData(j + 1) Then
TempValue = arrayData(j + 1)
arrayData(j + 1) = arrayData(j)
arrayData(j) = TempValue
End If
End If
Next
Next
sortArray = arrayData
End Function
'''''''''''''''''''''''''''''''''''''''''''''''''Function to view data in an array'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
public function ViewsortArray(arrayData)
For i = LBound(arrayData) to UBound(arrayData)
msgbox arrayData(i)
Next
End Function
'''''''''''''''''''''''''''''''''''''''''''''''''Function to compare two arrays'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Function funcArrayComparision(arrayA, arrayB)
''Firstly we will check whether the size of array matches, In case, It does not match, we can conclude values do not match
If ubound(arrayA) <> ubound(arrayB) Then
msgbox ("The array size is not same, so it is not possible array will match")
else
''Now first of all we need to sort the array content, since we are compring array value by value, we are sorting the data without taking as/desc order in focus
arrayA = sortArray(arrayA)
msgbox ("Sorted data in the ArrayA")
arrayB = sortArray(arrayB)
msgbox ("Sorted data in the ArrayB")
boolflag = 0
For i = 0 to ubound(arrayA)-1
If arrayA(i) = arrayB(i) Then
msgbox arrayb(i)
boolflag = 1
Exit For
End If
Next
If (boolflag > 0) Then
msgbox ("congratulation ! array content in both the files match")
else
msgbox ("array content in both the files does not match")
End If
End If
End Function
What is the difference between ByRef and ByVal? –QTP Interview question
Labels:
Basics of QTP,
VBScript
ByRef and ByVal are two ways to pass arguments to a function or subroutine in VBScript. Understanding the difference between two is simple.
Let us start with ByVal. Suppose a function or subroutine has an argument which accepts a variable with byval,suppose a variable x is passed as argument to the function, The value of variable does not change once the function is executed successfully.
Now let us move to ByRef. ByRef means passing value as a reference. Suppose a function or subroutine has an argument which accepts a variable with byref, suppose variable x is passed as argument to the function, The value of variable changes once the function is executed successfully.
Writing the below function in a notepad and running as a vbscript will help to differentiate ByVal and ByRef
By Ref Code:
Dim x
x= 5
call squareofNumber(x)
msgbox x
Function squareofNumber(ByRef varx)
varx = varx*varx
msgbox varx
End function
ByVal Code:
Dim x
x= 5
call squareofNumber(x)
msgbox x
Function squareofNumber(Byval varx)
varx
= varx*varx
msgbox varx
End function
By default, if we do not provide ByVal or Byref, it
takes the argument as ByRef.
Subscribe to:
Posts (Atom)