Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying Database Information
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00006222
Message ID:
00006240
Views:
47
>>>>>>I need to be able to display all relevant information about a database container (i.e. tables, fields, size of fields, type of field, comments, captions, etc.) in one printable listing. (Basically, a combination of the results of LIST STRUCTURE and LIST DATABASE commands.)
>>>>>>
>>>>>>Does anyone know how to do this?
>>>>>
>>>>>What you can do for this is write a little program, a combo of DISP TABLES to a file, then use AFIELDS on each table in the file to print the fields and other info. The LIST STRU doesn't work for long names (I hope that's a fix in a new version), so you have to format the output.
>>>>>
>>>>>Maybe someone else knows something quicker?
>>>>
>>>>the .dbc can be opened as a table -- why not create a report to print the info directly?
>>>
>>>That sounds good but where is the field info for the tables?
>>
>>objectname holds the name info for fields, indexes, tables, etc. objectid, parentid and objecttype tell what each is and how they're related.
>
>Yes, but what we're looking for here is field attributes. Don't you still have to use AFIELDS?

i think so. i guess i should try reading these when i'm awake....
Previous
Reply
Map
View

Click here to load this message in the networking platform