Control Statements › SELECT Statement › Considerations
Considerations
- A run can include multiple SELECT, SELECT(S), and SELECT(L) statements.
- Statements at different levels are processed separately. For example, SELECT(S) statements are handled independently of SELECT and SELECT(L) statements in the run.
- SELECT statements at the same level are assumed to be connected by AND. OR is only assumed when the same field name appears more than once.
Example:
SELECT WEEKDAY EQ SUNDAY AND ELAPS TIME GT 300
SELECT WEEKDAY EQ SATURDAY
These two statements have the same effect as the following single statement:
SELECT (WEEKDAY EQ SUNDAY AND ELAPS TIME GT 300) OR
WEEKDAY EQ SATURDAY
Only one SELECT SAME, SELECT NEW, COMPUTE IF SAME, or COMPUTE IF NEW may be coded for a given field.
|
Copyright © 2012 CA.
All rights reserved.
|
|