exporting field comments

[finglem]

I have managed to export into excel a list of all tables and fields from a VFP6 Database (with a lot of help from this community) I would also like to export the field comments. Is this possible? I have managed table comments but not the actual field comments.
Any ideas would be appreciated.

 

[baltman]

Try this:

MyTable_and_Field="MyTable.FieldName"

?DBGETPROP(MyTable_and_Field, "Field", "Comment&quot

Brian

 

[Mike Lewis]

Finglem,

When I saw your question, my first thought was: Use AFIELDS() and pick up the value in the 16th column of the array. But now I see that you are right: It returns the table comment, not the field comment.

I find that completely illogical. The function returns field-level information, but the comment is at the table level.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[alvechurchdata]

I thought I knew how to do this - but I was wrong.

I now know that field comments are held in a memo field named Property of the dbc table. There are unreadable characters before and after the comment but you might be able to extract the comments by reading the first contiguous string of alphanumerics.

WHy isn't there a smiley with a beard?

Geoff Franklin

http://www.alvechurchdata.co.uk