Hello Friends! In this post, we'll brush-up our understanding about vbscript arrays and to use arrays in QTP.
Fisrt thing first.. What is an Array?
- An array variable is used to store multiple values in a single variable.
- Array can contain a series of values of same data type.
- An array is a memory space referred by a common name.
Please note that VBScript explicitly supports only one data type - ‘Variant’. A variant can store a number as well as a string.
In vbscript, Arrays are of two types..
1. Static or Fixed Sized Array
2. Dynamic or Variable Sized Array
Both type of arrays can be of single dimensional or multi-dimensional. So to make the things simple, we can write this like...
1. Static or Fixed Sized Array
1.1. Single dimensional Static Array 'Exp - Dim myArray(4)
1.2. Multi-dimensional Static Array 'Exp - Dim myArray(3,4)
2. Dynamic or Variable Sized Array
2.1. Single dimensional Dynamic Array
2.2. Multi-dimensional Dynamic Array
1.2. Multi-dimensional Static Array 'Exp - Dim myArray(3,4)
2. Dynamic or Variable Sized Array
2.1. Single dimensional Dynamic Array
2.2. Multi-dimensional Dynamic Array
Sounds batter? Okey.. great!!
Dim myArray(4) 'declaring array in vbscript
In the above example, an array containing 5 elements is declared:
But why 5? The number shown in the parentheses is 4!!
Ya! But array index actually starts from zero, so this array contains 5 elements. This is a fixed-size array.
You assign data to each of the elements of the array like this:
myArray(0)= 21
myArray(1)= 42
myArray(2)= 51
myArray(3)= 33
myArray(4)= 15
It was one way of declaring and assigning values to an array.
Here is the another way...
Dim myArray
myArray = Array(21,42,51,33,15) 'integer values
myArray = Array("val1","val2","val3","val4","val5") 'string values
myArray = Array("1",2,"val3",4,"val5") 'mix of num and string values
As I mentioned above as well, VBScript explicitly supports only one data type - ‘Variant’. A variant can store a number as well as a string.
It was the VBScript Array Method of Creating Arrays.
Array we have discussed above is Static Array - Single dimensions. A Static Array -
- has a pre-defined number of elements.
- size of a static array cannot be altered at run time.
Multiple dimensions are declared by separating the numbers in the parentheses with commas. Here we have a two-dimensional array consisting of 5 rows and 7 columns:
Dim myArray(4,6)
In the above example, an array containing 5 rows and 7 columns has been declared.
Calculating the Size of Arrays:
ubound method is used to count the length of array. It returns the highest index number of the array.
But remember, the actual size of the array is highest index number plus one!! (since the array starts at index number 0).
Dim myArray(4), len1
len1 = ubound(myArray) '4
msgbox "Length of the Array is: " & len1+1 'output is 5
ubound method can be used to count the size of a multidimensional array also, but this time it's slightly different..
The dimension number needs to be included in ubound.
Dim myArray(4,6)
msgbox ubound(myArray, 1) 'shows highest index of the first dimension - 4
msgbox ubound(myArray, 2) 'shows highest index of the second dimension - 6
Tired! me too...!!
Another type of array is Dynamic array. In next part of post, we'll explore dynamic arrays and other good stuff about using arrays.
Please post your comments and tell me how you find this article!!
Hey Abhi...
ReplyDeleteIts quite helpful and elaborative just like class room session.
Good stuff!!
@Smiles
ReplyDeletethanks!! keep reading the good stuff!
thanks for valuable information...............
ReplyDeleteI have gone through multiple sites for learning an array in QTP , and it was not of much use , but the way you have explained it is in simple words and easy to understand, have never written any commentc for anything till date ,and this is the 1st time ever Im writting a comment as I was really impressed by your explanation.
ReplyDeleteKeep up the good work and expecting more on QTP scripting.
Thanks
Hi
ReplyDeleteI don't ur name
But what u r explaining is very useful n very easy to understand
Thanks
Good Stuff..!!
ReplyDeletevery nice
ReplyDeletereallly great
ReplyDeleteSupreb. Keep posting.
ReplyDeletefantastic stuff
ReplyDeletesimply great dude! keep up the good work!
ReplyDeletehi Abhi,
ReplyDeleteThanks for valuable information.
can pl explain how can we enter alues in multi dimentional static array
Thank you for the awesome information... guess what I love the pink backgroung :D
ReplyDeleteso much impressed and easily understandable...
ReplyDeletehow to click a multiple object dynamically in qtp example i want to click multiple webbutton dynamically?
ReplyDeleteThanks for your information, very useful :D
ReplyDeletecan you please explain wat is ubound and its function
ReplyDeleteEven i follow the exact process...
ReplyDeleteIt was really good
ReplyDeleteits really helpful for the people who really likes to learn QTP.
ReplyDeleteits better compared to class room.......
great work Abhi........
Abhi,
ReplyDeleteYou are just..too good.
@Priya - thanks for your words! I'm glad you like it.
ReplyDeletenice explanation
ReplyDeleteCan we have apply a filter on two dimensional array?
ReplyDeleteUseful
ReplyDeletegood
ReplyDeleteI read this article. I think You put a lot of effort to create this article. I appreciate your work.
ReplyDeleteClick Here : used motor grader cat 140h cca01812 for sale
Thank you for very usefull information. share more details guys.
ReplyDeleteAi & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai
This was an excellent post and very good information provided, Thanks for sharing. keep it up guys.
ReplyDeleteAi & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai
Great Post! Thanks for your Share.
ReplyDeleteQuality Onesie: Kigurumi Onesie Pajamas For Adults And Kids
Qualityonesie offers Pikachu, Disney, Anime, Hello Kitty, Animals, Winnie the Pooh, Stitch, Unicorn Kigurumi Onesie Pajamas for Adults and Kids.