Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Driven Design and Meta Tables
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01478896
Message ID:
01478897
Views:
75
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform