GetFieldServerType Method

Applies To

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

Arguments	Description
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:

Types	Description
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.