I have converted a shapefile into a geodatabase which I use for geocoding via the ILocator interface. It has the extension (.mdb) and contains address fields with a point which is stored as a long binary object (I think). I have queried it directory using libraries like OleDB. I'm wondering if there's a way to do a
SELECT * FROM mytable using the ArcEngine interfaces.
I'll provide some context as well. I'm trying to get around the inflexibility of the SoundEx implementation and some limitations with the locator styles. The locator style interace works like this for address search results:
IField addressField = candidateFields.get_Field(fieldIndex);
But the fields returned only match the fields in the locator, so I get "Zone" and not city, state, zip, unit number, owner name, parcel price, etc.