Sorry for all the SQL questions lately, I have a simple one and I just cant figure it out. I have a field that stores the name of a color selected from a value list like Blue, Green, Yellow, ect.
I am trying to do some conditioning formatting based on an SQL statement. In my statement, I check what the value of the ColorCode field is for a specific technicians name - but its returning ALL the colors instead of just one. Here is a slimmed down version of the statement that is causing the error:
ExecuteSQL("SELECT ColorCode FROM STAFF WHERE Staff_Name = ?"; ""; ""; STAFF::Staff_Name)
No matter what I put as the parameter, it returns all the possible colors. I can even just put a letter "a" as the parameter and it returns all the colors.
It seems to me there is an issue with trying to compare strings using = , but when I checked W3 site on SQL it seems this should work fine. What am I missing?