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

For each next loop - vbscript, A For Each...Next loop is similar to a For.....

A For Each...Next loop is similar to a For...Next loop. Rather than repeating the statements a particular number of times, For Each...Next loop repeats group of statements for each

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

Collection is adding last record, Please help me.. I am loading data from ...

Please help me.. I am loading data from a text file to a class (Item Inventory from Tony Gaddis - Visual Basic - Chapter 12 -programming challange# 7-9) and the last item loaded is

Array Program, Would it be possible to see an example of an array program t...

Would it be possible to see an example of an array program that tracks rent in different apartment buildings and is modular?

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

Loan program, need help with logic part of loan program

need help with logic part of loan program

Create a procedure - vbscript, Each piece of data is passed in your process...

Each piece of data is passed in your process using an argument. Arguments serve like placeholders for the data you wish to pass into your process. You can name your arguments along

Creation of the menu in visual basic, Creation of the Menu in VB 1. Ini...

Creation of the Menu in VB 1. Initiate a new project by choosing a file and then new project. 2. Now select the Standard EXE as the Project type. 3. Build the Form1 activ

Module - dialog box in visual basic, MODULE The Modules are the collect...

MODULE The Modules are the collection of VB statements. Modules are used to simplify the program development. To add a module to your project, choose the project tabpage, and t

Deleting records - data control, Deleting Records: To remove a record ...

Deleting Records: To remove a record use the Delete method. To delete the record from the customer table follow the coding as shown below: data1.RecordSource = "Customer"

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