Kbase P126196: SQL Dsv Does Not Evaluate Query Criteria in Where Clause Correctly
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/8/2008 |
|
Status: Unverified
SYMPTOM(s):
Where clause with more than one criteria is not bracketed incorrectly
Where clause contains an "OR" and "AND" conditions
The conditions in the where clause is evaluated incorrectly
The OR conditions proceeds AND condition in where clause
The AND condition is evaluated first instead of OR conditions
Happens with 10.1B02
Query works correctly in 10.0B and 10.1A
Problem occurs only against "For each" statement
FACT(s) (Environment):
OpenEdge 10.1B
OpenEdge 10.1B02 Service Pack
MS SQL DataServer
MS SQL 2000
CAUSE:
This is a known issue
FIX:
Explicitly bracket the conditions in the correct order.