Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ad Hoc Reports from SDT
Message
 
 
À
16/04/2001 14:49:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Divers
Thread ID:
00495894
Message ID:
00496106
Vues:
17
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform