ExecuteSQL Simple Arithmetic Issues

Discussion created by dlewis@taylor.n-lanark.sch.uk on May 11, 2018
Latest reply on May 11, 2018 by beverly

I'm using FMPro V16.0.5.500 on an MacBook Pro OS 10.12.5

I've wrote the script below which is not working

Screen Shot 2018-05-11 at 09.19.42.png

However if I remove the simple multiplication *100 the script works.


Can anyone enlighten me why the *100 is causing an issue?


I have the same issue with a few scripts which include simple arithmetic operations.


Sorry if I'm being totally stupid here.