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

#tit, anumberisprimeornot

anumberisprimeornot

Coding, Write an event procedure to automate the billing system of a superm...

Write an event procedure to automate the billing system of a supermarket. Give the details of database tables, forms, controls and menu design (if any). Make assumptions, wherever

Variant subtypes, Beyond the simple string or numeric classifications, Vari...

Beyond the simple string or numeric classifications, Variant can make added distinctions regarding the specific nature of numeric information. For instance, you can have numeric in

Crop image from tif and paste it on Excel Sheet, I have a tiff image of 25 ...

I have a tiff image of 25 pages. I capture particular square from particular page and past on one excel sheet one by one. it is possible, if yes how. Image have line no and pe

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

Introduction to database applications , INTRODUCTION TO DATABASE APPLICATIO...

INTRODUCTION TO DATABASE APPLICATIONS   In this section, we define a dialog and tab order that is the order in which the controls will be navigated during the execution. The D

Vb code to run various iterations , What I understand from the assignment i...

What I understand from the assignment is I have to make the VB code in file nu1. xlsm generic, and run several iterations for Kc and Ti to find out the optimal combination which wi

Illustration of mdi application using a project, ILLUSTRATION OF MDI APPLIC...

ILLUSTRATION OF MDI APPLICATION USING A PROJECT 1. Choose the MDI option while generating the project by using the Appwizard. 2. Add the WM_LBUTTONDOWN message for the view

Aim - control statement, Aim: To exhibit what is the day when the seco...

Aim: To exhibit what is the day when the second command button is clicked and to clear the screen when the first command button is clicked. The functioning of this program is

Help context property, Sets or returns context ID for topic in Help File. I...

Sets or returns context ID for topic in Help File. If Help file is indicated in the VBScript Err Object HelpFile Property, the HelpContext property is utilized to display automatic

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