Hello Community,
I have a named query that returns a cycle time (float column in SQL)
When I run the query in the Ignition query browser, I get a value returned which is 15,2. That is fine.
However the Ignition table shows it with multiple decimals.
Screenshot above is from the selection value of the table. Opening the dataset on the table directly it is shown fine
This is an issue because I use this value later on numeric fields.
I did build a way around it by rounding it and only displaying the last decimal, which works fine. However I wonder what the issue here is in Ignition adding the decimals that are not returned by the query ?
Btw. this is in Perspective
Thank you
Andreas