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?

Thanks

Jim

Outcomes