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

Create an application that calculates customer monthly bill, In this assign...

In this assignment, you will create an application that calculates and displays a customer's monthly cable bill. Your interface should look like this: Requirements:

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

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

External application window position, I have an external application I open...

I have an external application I open from visual studio (excel). I want to reposition where that opens (top, left).. How do I do that?

Visual processing - visual interface design, Visual Processing: Our mi...

Visual Processing: Our mind groups the things into patterns and this allows us to process the visual information. Understanding and applying how the human mind processes the v

Project to display a database - data control, A Project to Display a Databa...

A Project to Display a Database: 1. Suppose that there are 5 fields describing a customer. Id, address, name, city & state. 2. Put 5 text boxes on the form to exhibit the r

Windows 32 bit (win 32) applications, WINDOWS 32 BIT (WIN 32) APPLICATIONS ...

WINDOWS 32 BIT (WIN 32) APPLICATIONS   The Win 32 based applications are the applications developed for the windows family of the operating systems. The Win 32 applications ac

Dictionary, how to make dictionary in vb using ms access

how to make dictionary in vb using ms access

Making decisions with select case, The Select Case structure provides an op...

The Select Case structure provides an option to If...Then...Else If for selectively executing one block of statements from amongst multiple blocks of statements. Any Select Case st

Differences between Property Get, What are the differences between Property...

What are the differences between Property Get, Set and Let? Set - Value assigned to ActiveX Object from the form. Let - Value retried to ActiveX Object from the form. Get- Assigns

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