Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using LOOKUP() for value of coded fields
Message
De
06/09/1996 20:32:11
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Using LOOKUP() for value of coded fields
Divers
Thread ID:
00007373
Message ID:
00007373
Vues:
85
A table contains a field containing an abbreviation with the abbreviations and descriptions kept in a seperate abbreviations table how would one use the LOOKUP() to display the description rather than the abbreviation?

I've tried the following code in the textbox refresh event, but there seems to be a delay as I scroll thru the records.

LOCAL lcAbbrev
lcAbbrev = TRIM(THIS.value)
IF !USED("abbrev")
USE abbrev IN 0
ENDIF
SELECT abbrev
lcAbbrev = LOOKUP(descript, 'COLOR ' + lcAbbrev, abbrev, 'TYPE')
IF !EMPTY(lcAbbrev)
THIS.value = lcAbbrev
ENDIF


Kim
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform