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:
01478903
Views:
48
>>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).

I will look into this approach. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform