Skip Headers

Oracle® Objects for OLE C++ Class Library Developer's Guide
10g Release 1 (10.1)

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

GetFieldIndex Method

Applies To

ODynaset

Description

This method returns the index of the field indicated by fieldname.

Usage

int GetFieldIndex(const char *fieldname) const

Arguments

fieldname The name of the field as it appears in the SQL statement that the dynaset used most recently.

Remarks

Accessing fields of a dynaset by index is more efficient than accessing them by name. Therefore, if you need to access a particular field many times, use this method to translate its name into its index.

Return Value

The 0-based index of the field; -1 on error.

Example

This example looks at the salaries of many employees.

// open up the employee database

ODatabase empdb("ExampleDB", "scott", "tiger");

// get the main employee table

ODynaset emps(empdb, "select * from emp");

// now look at all their salaries

// let's get the index of the salary field for speed

int salind = emps.GetFieldIndex("sal");

double salary; // variable we'll use to get the salary

while (!emps.IsEOF())

{

emps.GetFieldValue(salind, &salary);

// do some processing

emps.MoveNext();

}