Kbase P54834: 4GL Query is not returning the result set expected by the de
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/11/2003 |
|
Status: Unverified
SYMPTOM(s):
4GL Query is not returning the result set expected by the developer.
CAUSE:
Logic error in the WHERE clause caused the query to CORRECTLY return a result set not expected by the developer.
FIX:
Correcting the logic in the WHERE clause returned the developer expected result set.
This situation occurs frequently during development. A developer constructs a query with the expectation of a specific result set to be returned and is surprised when the returned result set is not as the one expected. Usually a review of the Query conditions logic clears this issue.