Retrieving values from fields

When you have the cursor at the row you want, use the GetColumnValue method to fetch the value for a field of that record.

If you created your query using ...

The order of the columns corresponds to ...

the QueryDef object

the order in which you added fields using BuildField.

a SQL statement

the SQL statement

(To discover which column has the data you want, use the ResultSet object: GetNumberOfColumns, GetColumnType, and GetColumnLabel.)