Being the detail oriented guy that I am (uh huh), I decided to automatically generate a data dictionary in my framework. The datadict is really two table, one containing table information and one containing field information. The problem I've run into is when trying to generate the table that contains field info. Basically, I attempted to do the following:
scan
get table name from datadict
display structure to a file
append that file to a temporary table
get rid of the strucure header info
add any extra info to the temp table, eg table name
append the temp table into the main table
endscan
This works great with one exception. The file output from the 'display struct to file' isn't always the same! So, for example, since I'm assuming that the 'field type' will always start at column 30 this trashes everything.
Is there an easier way to get structure info into a table?