Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data normalization question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01515001
Message ID:
01515005
Vues:
46
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform