Select and Fetch Details

[Das Goravani]

Well putting my calculation straight into the SELECT line did the trick, along with setting the decimal places to zero on the hash variables. It worked immediately and well. So it was the putting of the statement into $S5 first and the decimal places that were causing the problem.

Sorry, this was pretty simple. I should be able to do this type of debugging on my own. Sorry.



> On Oct 18, 2021, at 10:43 AM, Paul Manning via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Couple of things
> The @ may not be evaluating properly as it is contained as part of a calculation and not sent directly to the $select.  You may have to use [eval(#S5)]
> You could try casting the # variables in the calculation ie #1D0 
> The trouble with these hash variables is they will retain the decimal places that were last used with it, so you need to set the decimal places each time they are used to be safe.
> 
> 
> Paul
> 
> ************************************************
> Paul R. Manning
> paulrmanning58 at icloud.com <mailto:paulrmanning58 at icloud.com>
> 
> 
>> On Oct 18, 2021, at 10:31 AM, Das Goravani <goravanis at gmail.com> wrote:
>> 
>> 
>> 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
>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com