General information
Category:
Coding, syntax & commands
Besides AFIELDS() (that Steve Johnson already mentioned), FoxPro provides the command COPY STRUCTURE EXTENDED that copies the structure of a table to a table. The structure of the resulted table is basically the same as the array generated by AFIELDS.
Vlad
>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only