Variant subtypes, Visual Basic Programming

Assignment Help:

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 information which represents a date or a time. While used with other date or time data, the result is expressed as a time or date. You can also contain a rich variety of numeric information ranging from Boolean values to enormous floating-point numbers. These distinct categories of information which can be contained in a Variant are called subtypes. Mostly time, you can just put the type of data you desire in a Variant, & the Variant acts in a way that is most suitable for the data it contains.

The following table illustrates the subtypes of data that a Variant can contain.

Subtype

Description

EmptyVariant

Uninitialized. Value is 0 for numeric variables or a zero-length string

("") for string variables.

NullVariant

Intentionally have no valid data.

Boolean

Contains either True or False.

Byte

Contains integer in range 0 to 255.

Integer

Contains integer in range -32,768 to 32,767.

Currency

-922,337,203,685,477.5808 to 922,337,203,685,477.5807.

Long

Have integer in range -2,147,483,648 to 2,147,483,647.

Single

Have a single-precision, floating-point number in the range -

3.402823E38 to -1.401298E-45 for -ve values; 1.401298E-45 to

3.402823E38 for positive values.

Double

Have a double-precision, floating-point number in the range -

1.79769313486232E308 to -4.94065645841247E-324 for -ve values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values.

Date

Have a number that represents a date between January 1, 100 to

December 31, 9999.

Time

Represents a time among 0:00:00 and 23:59:59

String

Have a variable-length string which can be up to approximately 2 billion characters in length.

Object

Have an object.

Error

Have an error number.

You can employ conversion functions to changed data from one subtype to another. Additionally, the VarType function returns information regarding how your data is stored within a Variant.


Related Discussions:- Variant subtypes

To calculate rectangle, two sides are given of a sheet e.g 23*36 i want hal...

two sides are given of a sheet e.g 23*36 i want half or 1/2 of this sheet next i want 1/4(one fourth) of this sheet if sheet size is 23*36 next i want 1/8 similary as above

Switch 2 images, I have a problem with Visual Basic: exchangeable 2 image...

I have a problem with Visual Basic: exchangeable 2 images of place I have 2 picturebox''s placed a button when I click on the button, the 2 pictures of this place change with e

Message box - dialog box in visual basic, Message Box: The Message Box...

Message Box: The Message Box can be specified a title as shown in figure to specify the title for the message box follow by the command given below:  Private Sub Command1_C

Vb script coding conventions, Coding conventions are recommended that may h...

Coding conventions are recommended that may help you write code via Microsoft Visual Basic Scripting Edition. Coding conventions can include the given: Naming conventions for ob

Dialog boxes in vb, DIALOG BOXES IN VB The two dialog boxes, namely, th...

DIALOG BOXES IN VB The two dialog boxes, namely, the message box and the input box are usually used in the Visual Basic. The message box is used for displaying the messages to

Gdi object cpen, Illustration of GDI object CPen: 1. Generate a SDI ap...

Illustration of GDI object CPen: 1. Generate a SDI application. And name it as gdipen. 2. Press ctrl (control key) and W altogether to invoke the class wizard. 3. Choose

Displaying the file without scrolling - document class, Displaying the file...

Displaying the file Without Scrolling: To display a file follow the steps as shown below: 1. Generate a SDI application. 2. Type the coding as shown in the Serialize els

Vb program for simple image processing, A program needs to be written that ...

A program needs to be written that is capable of simple image processing. All the images that are available for you to use, can be found on Blackboard in the Assignments section. T

ER DIAGRAM FOR DISTRIBUTER MANAGEMENT, HOW TO MAKE ER DIAGRAM FOR DISTRIBUT...

HOW TO MAKE ER DIAGRAM FOR DISTRIBUTER MANAGEMNET OF WATER PURIFIAR

Vbscript constants, A constant is a meaningful name which takes the place o...

A constant is a meaningful name which takes the place of a number or string and never alters. VBScript described a number of intrinsic constants. You can get thorough information r

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