Select and Fetch Details
goravanis at gmail.com
Mon Oct 18 14:31:54 UTC 2021
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?
More information about the omnisdev-en