AnsweredAssumed Answered

ExecuteSQL function syntax for quotes

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


ExecuteSQL function syntax for quotes



     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?