Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to emulate variant field?
Message
From
22/03/2006 08:11:21
 
 
To
22/03/2006 08:06:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01106541
Message ID:
01106570
Views:
26
>>Can you give an example why you need a "variant" field?
>
>Example 1 - to store application settings like window sizes and user preferences. I use a table with only two fields Name and Value. Each setting has unique name and their values are of different types.
>
>Example 2 - to store custom object properties. The list of properties is not predefined and also objects with different sets of properties may be "stored" in the same table.

Add a third field for data type, and store all data as text. I have used that solution for many years.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform