AnsweredAssumed Answered

Execute SQL Error

Question asked by madmike6537 on Oct 14, 2014
Latest reply on Oct 15, 2014 by beverly

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?

Outcomes