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?