Doug,

I found this thread and I am a little confused. I would like the ability to read/write the field captions in my database. This way I can let my users change on screen field labels and have those changes reflected in both SFQuery and SFReports.

Your suggestion below talks about adding the field captions into the meta data, is this still the preffered way?

Kind Regards,

Mat

By Copy to Bob: How did you decide to handle this?


>Hi Bob.
>
>>oMeta.SetDataBase('MyData')
>>oMeta.DBCXGetProp('MyTable.MyField','FIELD','Caption')
>>
>>It returns nothing... I can see the caption in both the SDT Ap and in the DataBase if I modify the table and select that field.
>
>I replied to your email on this, but figured I'd also answer it here if anyone else was curious.
>
>The reason it returns nothing is that SDT uses the DBC Caption property for
>a field. The DBCX Caption property is intended for those data objects (eg
>tables and indexes) that don't have a native Caption property.
>
>That said, you could easily put field captions into the meta data so you can
>use DBCXGetProp. A simple program could spin through all fields in all
>tables, use DBGETPROP to read the field caption from the DBC, and
>DBCXSetProp to store the caption in the meta data.
>
>Doug