Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to emulate variant field?
Message
De
22/03/2006 08:11:21
 
 
À
22/03/2006 08:06:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01106541
Message ID:
01106570
Vues:
28
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform