Kbase P12793: Report Builder Engine is taking a long time to run
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Report Builder Engine is taking a long time to run
NEGATED SYMPTOM(s):
Filter "pickhist.ftim NE ?" is causing the delay
"?" in a filter in rbengine seems to cause slowdown
CAUSE:
Filter "pickhist.ftim NE ?" is causing the delay
CAUSE:
Report Builder is having issues translating the query from 4gl to RB with a ? in the filter.
FIX:
Modify the filter to work around the ? value;
Filter Example
pickhist.ftim <> -1 and pickhist.ftim >=0
That will automatically disregard any record where pickhist.ftim = ?.