AnsweredAssumed Answered

Strange value selected by EXECUTESQL

Question asked by jimhohnc on Mar 5, 2018
Latest reply on Mar 8, 2018 by jimhohnc

Hi everyone,


I encountered a strange issue during I select 2 numbers by EXECUTESQL when I use the selected numbers in an "IF" statement.

It is From and To counter.


Somehow the comparison is wrong as below.

From: 2; To: 3 ==> IF i<From or i>To, set field "X"


1     2     3     4     5     6     7     8     9     10

x                   x     x     x     x     x     x                   


10 is missing!   


How I solved the problem is  " *1 " after the EXECUTESQL statement.... Because seems it does acts as a number at all times. I tried to force it to be a number. It spent me a few days to figure out what's wrong with my loop.......


Can anyone explain what's wrong with my script?