Select and Fetch Details

Das Goravani goravanis at
Mon Oct 18 14:31:54 UTC 2021

Hello List,

I’m having a hard time with a SELECT and FETCH.

This is the key code

Calculate #S5 as con(pwhereclause,' AND nrsn>=@[#1] AND nrsn<=@[#2]')
Do lLoadList.$select([#S5]) Returns #F
Do lLoadList.$fetch(500) Returns lFetchStatus

I should be getting zero records returned, or very few.

Instead I am getting 500 and they don’t match the search criteria.

It is as if my search is being ignored. By Search I mean my SELECT parameters.

The whole WHERE clause looks like this:

WHERE chcateg=0 AND nrsn>=1 and nrsn<=500

First, why is my search being ignored?

Second, if it was working, you only get back what matches the search criteria correct?  Like although I say “return 500 records” it will in fact only return 300 if that is all that matched the search, correct?

Thank you,

Das Goravani

More information about the omnisdev-en mailing list