>>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)
Thank you, Dragan. I will try your approach too. I have not had a chance to work on this issue today as I was traveling all day.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham