I am writing some code that will run an SQL query against the FGDB using the FGDB API 1.2. The SQL will be defined at runtime. I am finding that the EnumRows class is not filtered on the fields in the select clause of the SQL statement, the EnumRows always has attributes for all fields even with a SQL statement like "SELECT CITY_NAME, POP1990 FROM Cities WHERE TYPE = 'city' AND OBJECTID < 10". Because the EnumRows class's fields are not filtered, the GetFieldInformation returns information about all fields in the table not the fields in the select clause.
Am I missing something in the use of the SQL comnponents of the API? If not, how do I determine field names, types, etc. on a SQL query supplied at runtime?
Thanks
