>I have a scenario where I need to go to the DBC to find a field's table name. In this scenario, I am assured that field names in the DBC are unique.
>
>Has anyone done this before, in an efficient SQL statement. I know this can be done with multiple passes on the DBC inspecting [objectname], [objecttype] and [parentid]...
>
>Any help is most appreciated.
I would create a table with DB information, first, and then fetch information from that table. I do not suggest you open the DBC as a table; instead, you can open the database, get the list of tables with adbobjects(), then get the fields for each table with afields().
Save all the information to a table - fields: "table", "field", and whatever other information from the 16 afields() columns you find relevant - and then start foolin' around with it.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)