Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making surrogate keys, the Tastrade way
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00053840
Message ID:
00054098
Vues:
37
>>Bret, VFP3 has problems handling numeric fields in Combo boxes. You may be using your IDs as the bound field in combos, particularly for lookup tables. Using Character fields avoids the problem, and it's easy to use a PadL() function to stuff leading zeroes into the character field.
>>
>>In VFP5, the combo problem was fixed.
>>
>>HTH
>>Barbara
>
>If my keys are not used as invoice numbers or something, why would I ever want my users to see them?

Bret, not for the users to see. In a lookup table, I often store the key field value, but want the user to see the description. In the combo, VALUE is the key field, DISPLAY VALUE is the description.

Hope this is clearer,
Barbara
Barbara Paltiel, Paltiel Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform