Kbase P16095: How to define a multiple field query and useing an or clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2003 |
|
Status: Unverified
GOAL:
How to define a multiple field query using the OR clause.
FIX:
If we were querying the Customer Table and wanted all the customers that were in a specific State and have a specific balance but, could be represented by one of two Sales Reps we would use the following syntax;
FOR EACH customer WHERE State = "MA" AND Balance > 0 AND ( salesrep = "HXM" OR
salesrep = "SLS"):