Oracle® Objects for OLE C++ Class Library Developer's Guide 10g Release 1 (10.1) Part Number B10119-01 |
|
Applies To
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();
}