4 Replies Latest reply on Oct 15, 2014 12:58 AM by beverly

    Execute SQL Error


      Hello all,


      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?