For SDT properties, look at DBCXGetProp() function. For DBC properties, look at DBGetProp() in the VFP Help. You could create a cursor with the fields to contain the information you want. After the cursor has been built with all the data, you can index it before you run your report.
>I want to write a report that combines some data frome SDT and the description of the tables. What I want is a report listing all tables, views, and field in a database with the following layout:
>
> fieldname, tablename, format, caption, and description
>
>sorted by fieldname, and tablename. Some of the information is in SDT table coremeta and some of it is in the VFP database table (i.e. captions and descriptions for fields). Can I do this? If so how?
>
>1. what table am I looking for and what is the use command to access it in read only mode (I tried unsuccesfully to do this).
>2. what if any is the common field between two tables (SDT and database)?
>3. what are the relevant field names?
>
>Any other pointers
Mark McCasland
Midlothian, TX USA