Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Flag for a value in a list
Message
From
14/01/2000 09:59:31
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Flag for a value in a list
Miscellaneous
Thread ID:
00318140
Message ID:
00318140
Views:
66
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?
Next
Reply
Map
View

Click here to load this message in the networking platform