AnsweredAssumed Answered

ExecuteSQL function syntax for quotes

Question asked by RichNasser on Mar 28, 2014
Latest reply on Mar 28, 2014 by RichNasser

Title

ExecuteSQL function syntax for quotes

Post

     Hi:

     I have read the documentation provided by FileMaker regarding the ExecuteSQL function.  I am having trouble using it in a field calculation as I don't know how to handle the quotes.  For instance, if I want to use a SELECT statement in the function, I have to use "SELECT * FROM...." but if in this statement I need a WHERE status = 'Paid' I get an error.  Does anyone know the correct syntax for quotes usage?


     Thanks

Outcomes