Skip Headers
Oracle® Objects for OLE C++ Class Library Developer's Guide
10g Release 2 (10.2)

Part Number B14308-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

GetField Method

Applies To

ODynaset

OFieldCollection

Description

This method returns one of the associated field objects by way of an OField handle.

Usage

OField GetField(int index) const

OField GetField(const char *fieldname) const (for ODynaset only)

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

This method returns an OField object on the indicated field. The field object remains valid until the dynaset is refreshed or destroyed.

When getting a field from an OFieldCollection, the 0-based index still refers to a SQL query. Specifically, it refers to the SQL query of the dynaset that the OFieldCollection was gotten from.

Return Value

An OField, which will be open on success, closed on failure.

Example

This example demonstrates getting fields.

// open an ODatabase
ODatabase odb("ExampleDB", "scott/tiger", 0);

// open an ODynaset
ODynaset dyn;
dyn.Open(odb, "select empno, ename, nvl(comm,0), hiredate date \
               from emp");

// get a field by index
OField empnofield = dyn.GetField(0);

// get a field by name
OField namefield = dyn.GetField("ename");

// get a computed field by name
//    we use the expression (which is the column name)
OField commfield = dyn.GetField("nvl(comm,0)");

// get a field that has been aliased - the column name is the alias
OField datefield = dyn.GetField("date");