>I need to create a table/cursor of all fields in a DB container that have a certain value in Comment property. For each one of those fields I need to store value of Class and DisplayClassLibrary values.
>
>For example, say some of the fields have value in Comment property as "MYCOMMENT". So I would need to find all fields that have this value in the Comment property and output them to a table something like the following:
>
>FLD_NAME, C, 100
>CLASS, C, 100
>CLASSLIB, C, 100
>
>Thank you in advance for any suggestions.
Of course, apart from the esteemed colleagues' hacks into the dbc itself, there's also the regular way... use ADBOBJECTS(aTbl,"TABLE") to get a list of all of your tables in the dbc, then for each table use afields() to get
lcComment=DBGETPROP(forceext(lcTable, lcfield),"FIELD","Comment")
And then if the comment fits your criteria, insert values into your cursor.
(just to keep up with the tradition: if it can't be done at least three ways in Fox, it isn't worth doing)