I have been getting this error when I run a SQL query and it returns no rows. If I check the enable box for the Fallback Value and give it a value, it still gives me the same error.
If the SQL query does return any rows, then I get no errors.
Exception: Conversion error: query returned null, binding needs “double”
on query binding for “ExtruderTime7.Root Container.TimeFromDB.value”
Right, the fallback value is for when the query returns NO rows. You are running into the case where the query is returning a row and the value is NULL. You need to use the COALESCE function to convert a NULL to something else in your SQL query.SELECT COALESCE(Column, "Fall Back Value") FROM Table WHERE ....