Hi
Now I understand.
To get fields descriptions you must query the system table rdb$relation_fields
table_name = ...
SQLEXEC(1,[SELECT RDB$FIELD_NAME, RDB$RELATION_NAME,RDB$DESCRIPTION FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME=?table_name])
Then you can scan the cursor and set caption property using DBSETPROP() function.
(I'm curious if this function works, because in VFP7 seems broken for "FIELD" type object)
>Hi Dorin
>
>>What exactly do you want?
>
>I want to pull in the desctiptions I have typed for the field, tables. I haven't seen a place to write a caption for a field (maybe I can tackle the field description once I get it). the idea is to get them into the remote views in VFP and once there the drag and drop of fields can be done so that the labeling can be automated using these descriptions from FB.
>
>I hope I have been able to clarify my requirements.
>
>Thanks.
>
>>SQLTABLES() function can be used to retrieve tables from database.