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
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");