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

Select case - control statement, Select Case: The Select Case is used ...

Select Case: The Select Case is used for handling the multiple paths. The Select Case computes the expression and depending on the value of the equivalent Case statement execu

Write a program to sort and display an array, Problem 1. Describe the i...

Problem 1. Describe the importance and usage of .net framework in visual Studio 2. Write a program to sort and display an array of integers in ascending order using the conc

Visual interface based on visual patterns , Visual Interface  Based On Vis...

Visual Interface  Based On Visual Patterns: The visual user interface should create recognizable patterns and text will be used for differentiating the objects with similar pa

Match Game, I would like someone to look at my code and tell me why it''s n...

I would like someone to look at my code and tell me why it''s not working

While loop - vbscript, In VBScript, the While...Wend statement is provided ...

In VBScript, the While...Wend statement is provided for those who are familiar along its usage. However, due to the lack of flexibility in While...Wend, it is suggested that you us

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

Web Scraping via program, I''m trying to create a program in VB.net that wi...

I''m trying to create a program in VB.net that will basically load the page within itself and allow you to input data via the program rather than going to the actual site using you

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

Visual basic program, Create the flowcharts using MS Visio, MS Excel or MS ...

Create the flowcharts using MS Visio, MS Excel or MS Word to demonstrate the algorithm. Submit your flowchart under the assignment for CH7-4-26 Flowchart. Part Printouts H

How to include list box control in visual basic project, How to Include Lis...

How to Include List Box control in your project A list box is used for representing the users with a data. You can prefer the data from the list box for data entry. No editing

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