I am having issues with an ExecuteSQL statement. I am using this exact statement for other tables and fields and it works great, but when I run it for this table / field - it comes back with a "?". I cannot figure what I am missing here. This table is on my relationship graph as well with this exact name.
ExecuteSQL ( "SELECT Material_Name FROM Material_Reading WHERE _Room_KF = 4089"; "";"")
If I remove the WHERE _Room_KF = 4089 it works great, and returns all results. ( this is just temporary I am actually using arguments in the regular calc)
I have verified that there definitely is a record in the Material Reading table with a roomKF that equals 4089, and I have tried other rooms ID's as well. I cant figure out why its returning as ?. The docs state this is because of an error. What could I be missing?