Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data normalization question
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01515001
Message ID:
01515005
Views:
45
You might want to take a look at the Stonefield Database Toolkit - ...it deals with metadata and adds extended features to the database properties for database objects. If I understand what it is you're trying to do, I've done something similar with SDT. (And SDT is one of my all time favorite VFP goodies)

http://www.stonefield.com/sdt.aspx

>I want to define a group of normalized tables so that it is straightforward to define new types of detail fields in a data dictionary to accomodate customer requests.
>
>At runtime I will use a crosstab cursor to group detail fields into logical (virtual) records. These virtual records will be used for data entry, in grids, in reports etc. The records will contain all columns defined in the data dictionary.
>
>I am tempted to split the virtual records in two. The first part would be a physical table with the fields common to all users of the application, and the second part would be a cross table with the extra fields defined in the data dictionary. The physical table and the virtual table would have a one to one relationship. The motivation is that is seems like a big waste of resources to always have to create a cross tab table that includes "permament" fields.
>
>I'd welcome your comments and recommendations.
>
>TIA,
>
>Alex
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform