Interface index  Fields collection

Chapter 4: ActiveX Client Interfaces

Field interface

Description

Type library name

JaguarTypeLibrary

DLL name

jagproxy.dll

Represents one column in a row of tabular data.

Properties

Usage

For sample code that accesses a Field object’s properties, see Chapter 20, “Creating ActiveX Clients,” in the EAServer Programmer’s Guide.

Table 4-1 lists SQL datatypes, the corresponding values for the Type property, and the corresponding Variant datatypes for the Value property. Values for the type property are defined in the DataTypeEnum enumeration. The table lists both the symbolic DataTypeEnum values and the numeric constants that they represent. Some automation controllers may not be able to use symbolic values from an enumeration; in these controllers, use the numeric constant instead.

Table 4-1: The Field.Type and Field.Value properties

SQL datatype

Field.Type constant

Field.Value return type

BIT, or 1 bit of data

adBoolean (11)

VT_BOOL (1 maps to true)

TINYINT, an 1-byte integer

adTinyInt (16)

VT_UI1

SMALLINT, a 2-byte integer

adSmallInt (2)

VT_I2

INTEGER, a 4-byte integer

adInteger (3)

VT_I4

FLOAT, an 8-byte floating point number

adDouble (5)

VT_R8

CHAR, string values that do not vary in length

adChar (129)

VT_BSTR

VARCHAR, string values that can vary in length

adVarChar (200)

VT_BSTR

BINARY, an array of bytes that does not vary in length

adBinary (128)

VT_ARRAY

VARBINARY, an array of bytes that may vary in length

adVarBinary (204)

VT_ARRAY

NUMERIC, a fixed-point decimal number

adNumeric (131)

VT_R8 (No direct mapping exists. Mapped to 8-byte floating point)

DECIMAL, a fixed-point decimal number

adDecimal (14)

VT_R8 (No direct mapping exists. Mapped to 8-byte floating point)

DATE, a date value including the time-of-day

adDate (7)

VT_DATE

MONEY, a cash value

adCurrency (6)

VT_CY

See also

RecordSet interface, Fields





Copyright © 2005. Sybase Inc. All rights reserved. Fields collection