GetFieldServerType Method

Applies To

ODynaset

Description

This method returns the Oracle type of the specified field in the database.

Usage

int GetFieldServerType(int index) const

int GetFieldServerType(const char *fieldname) const

Arguments

index the 0-based index of the field. The index is the position of the field in the SQL query that created the current record set.

fieldname the name of the field, as expressed in the SQL query

Remarks

Every column in an Oracle database and every column computed in a SQL statement has a type. This method returns the type of the specified field. It will have one of the following values:

OTYPE_VARCHAR2 varchar2, variable length character

OTYPE_NUMBER numeric field

OTYPE_LONG long text (> 2000 bytes)

OTYPE_ROWID Oracle rowid

OTYPE_DATE a date

OTYPE_RAW raw bytes

OTYPE_LONGRAW long blob of bytes (generally > 255 bytes)

OTYPE_CHAR fixed-length text

OTYPE_MSLABEL special type for Trusted Oracle

For more information on these types consult the Oracle SQL Language Reference Manual.

Return Value

An integer which identifies the type of the specified field.