Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ad Hoc Reports from SDT
Message
 
 
To
16/04/2001 14:49:43
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00495894
Message ID:
00496106
Views:
16
>Please excuse me if this is a repost. I could not find my original post and there are no replies.
>
>I would like to write a report that list, table names, field names indexes, format, and coments sort by each of these
>fields check for consistancy. Before I re-invent the wheel has any one does something like this? If not amy pointers
>to appropriate dbfs, field names, and set up code would be appreicated.

Please clarify. Are you using SDT? It is in your subject line but you do not refer to it in your question. SDT does provide several options for documenting your database. Have you selected several options and previewed the generated output?

If that is not adequate, you will have to roll your own. I would use ADBObjects() to get an array of tables and views. The easiest way would be to loop through those arrays to open views and tables. Then use AFields() to get the field info. You can use Tag() and TagCount() functions to get Key() expressions for the indexes on each table. DBGetProp() will get you the table or view comment.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform