Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Flag for a value in a list
Message
De
14/01/2000 09:59:31
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvanie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Flag for a value in a list
Divers
Thread ID:
00318140
Message ID:
00318140
Vues:
65
10 entries of Rep,month,pub

Sele Rep,iif(pub="SA",.T.,.F.) as SA_flag Group by Rep

I want to flag those reps who worked on the SA pub, while also selecting the list of reps. Will this statement work? (in testing, it appears to work) My concern is that if another pub value occurs in the selection after the "SA" value, that the SA_flag value will return to the .F. state.

The alternative is to do 2 separate selections for each group, but i don't want to have to do that...

Any suggestions?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform