Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and Entity-Attribute-Value
Message
From
20/12/2006 13:13:01
 
 
To
20/12/2006 12:58:54
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01179283
Message ID:
01179289
Views:
10
>Does somebody else tried to implement Entity-Attribute-Value (EAV) model with VFP? Or it is better to go with XML if I need something more flexible than flat tables?

I am not familiar with that concept but when it comes down to go far beyond that what the structure supports, I use a data dictionary table for it. The XML is a good approach. But, I prefer to use a data dictionary as it allows me to benefit of the same data mechanism as is the data. So, I wouldn't have to apply some XML data access and such. This will also allow me to obtain fully optimizable queries.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform