Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Driven Design and Meta Tables
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01478896
Message ID:
01478897
Vues:
74
>Hi,
>
>I want to implement a data-driven approach of defining properties of various CursorAdapter objects in my application. So I need to store the values of the column names, types, etc. etc. in meta table(s). I am considering 3 options for meta data:
>
>1. .DBF files (even though the application work with SQL Server database)
>2. XML files
>3. Table(s) in SQL Server.
>
>Which one of the above you (collectively) would use? TIA.

If you're using SQL Server, this information is already available to use in various meta-tables (views)

Say, you can check Information_Schema.Columns to get information about columns and you can look into extended properties to get descriptions of the fields (if you need to get this information too).
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform