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

}