ExecuteSQL syntax question

[doughemi]

I am trying to use ExecuteSQL() for the first time, and have run into the dreaded "?" for a very simple query.

 

I want to count all the records in the Games table where the field Won_Lost contains "WON".

 

My calc is

 

 

ExecuteSQL (

 "SELECT count(*)

FROM Games

WHERE Won_Lost = "WON" ";

 "" ; "" )

 

What have I done wrong?

[Brooks]

Where Won_Lost = ? " ; "" ; "" ; "WON" )

[doughemi]

Thanks, Brooks

[David Jondreau]

The string WON should have single quotes, not double quotes (and hence no escaping either).

[doughemi]

Thanks, David.  I'm glad to be getting another arrow in the quiver.