Scalar variables and array variables, Visual Basic Programming

Assignment Help:

Mostly time, you just desire to assign a single value to a variable you have declared. A variable having a single value is a scalar variable. At other times, this is convenient to assign more than one associated value to a single variable. Then you can create a variable which can have a series of values. It is called an array variable. Array variables & scalar variables are declared in the same way, apart from that the declaration of an array variable employee parentheses ( ) following the variable name. In the following instance, a single-dimension array having 11 elements is declared:

Dim A(10)

Although the number illustrated in the parentheses is ten, in VBScript all arrays are counted from base 0, so that actually this array contains 11 elements. In such an array, the number of array elements is always the number illustrated in parentheses plus one. This kind of array is known as fixed-size array.

You assign data to each of the elements of the array via an index into the array. Starting at zero and ending at 10, data will be assigned to the elements of an array given as:

A(0) = 256

A(1) = 324

A(2) = 100

. . .

A(10) = 55

Likewise, the data can be retrieved from any element via an index in the specific array element you desire. For illustration:

. . .

SomeVariable = A(8)

. . .

Arrays are not restricted to a single dimension. You can have as several as 60 dimensions, although mostly people cannot comprehend more than three or four dimensions. Multiple dimensions are declared through separating an array's size numbers in the parentheses along commas. In the following instance, the MyTable variable is two-dimensional array having 6 rows and 11 columns:

Dim MyTable(5, 10)

In a two-dimensional array, always the first number is of rows; the second number is of columns.

You can also declare an array whose size alter whereas your script is running. It is called a dynamic array. Initially the array is declared in a process either using the Dim statement or the ReDim statement. Though, for a dynamic array, no size or number of dimensions is placed inside the parentheses.

For instance: Dim MyArray()

ReDim AnotherArray()

To employ a dynamic array, you have to subsequently use ReDim to find out the number of dimensions and the size of each dimension. In the following instance, ReDim sets the initial size of the dynamic array to 25. A subsequent ReDim statement resizes array to 30, however uses the Preserve keyword to preserve the contents of the array as the resizing takes place.

ReDim MyArray(25)

. . .

ReDim Preserve MyArray(30)

There is no limitation to the number of times you can resize dynamic array, although you should know that if you make an array smaller than it was, you lose the data in the removed elements.


Related Discussions:- Scalar variables and array variables

Create a vb application to make the text bold, Question 1 Create a VB appl...

Question 1 Create a VB application to make the text bold, italic, underlined and also color the text (using checkbox, option button, textbox controls) Question 2 Create a

Operator precedence - vbscript operators, While several operations take pla...

While several operations take place in an expression, each part is evaluated & resolved in a predetermined order called operator precedence. You can employ parentheses to override

Displaying the database - data control, Displaying The Database: The T...

Displaying The Database: The Text box, image box, check box, labels, picture box can be bounded to the data control for exhibiting the data base contents. The two properties a

Program to order a product from inventory, Write a program that permits the...

Write a program that permits the user to order a product from inventory. The user selects the product and enters the quantity. If there is sufficient quantity on hand of the produc

Introduction to visual basic, INTRODUCTION TO VB: The Windows programmi...

INTRODUCTION TO VB: The Windows programming is an event driven programming. The VB uses the Hungarian Notation for naming the variables. It deals with new data types like HWND,

Program to draw a rectangle shape , Create a project that draw a rectangle ...

Create a project that draw a rectangle shape which may be either (*) or (+) according to the selected radio button. The number of rows in the shape will be taken from the 1 st

Application that determines the optimal inventory policy, Objective: To dev...

Objective: To develop an Application (Excel + VBA) that determines the optimal inventory policy under an All-Units Discount scheme. APPLICATION CHARACTERISTICS Consider the

Object naming conventions, The following table lists suggested conventions ...

The following table lists suggested conventions for objects you might encounter while programming VBScript. Code Commenting Conventions All process should begin with a brie

Cell phone application, to dial a person''s 10 digit number and assign it t...

to dial a person''s 10 digit number and assign it to their name

Need help on macros in visual basic, I have an excel list with a lot's of s...

I have an excel list with a lot's of serial numbers that have been entered by hand from PDFs online (1-5 serial numbers per PDF). Many of the values are duplicates, wrong, or conta

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd