Cannot get simple ExecuteSQL Query to run

[James Gill]

Hello,

I'm relatively new to SQL but I'm pretty experienced in Filemaker. Because of the addition of the ExecuteSQL command, I'm judging whether or not to move a solution that I'm currently working on over to FM12 so that I can potentially simply the ERD but I'm having trouble even getting a relatively simple ExecuteSQL calculation to run without error.

Basically, I have a table in my solution called ITAssignments that contains an text field called "id and a text field called "Who". I created a TO dedicated to the IT Assignments called SQL_ITAssignments

Here's my query:

ExecuteSQL ( "

SELECT id

FROM SQL_ITAssignments

WHERE Who = James"

; "" ; ¶ )

Unfortunately it returns a "?" and I'm not sure why...

[mr_vodka]

You need single quotes for the text string

ExecuteSQL ( "SELECT id FROM SQL_ITAssignments WHERE Who = 'James'" ; "" ; "" )

[James Gill]

Ah, that's why...thanks!