Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A Detailed Data Dictionary
Message
From
07/08/1997 10:59:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00043518
Message ID:
00043525
Views:
34
>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?
Since data dict. for VFP is built-in I assume you want to make it for older versions. I have done it before for my projects and posting the code to your mail address. I have a trouble with my mailer so I will do it from elsewhere for the moment.
I hope it helps.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform