My Lazy ExecuteSQL Template for FileMaker
I don’t use ExecuteSQL as much as I used to, but this template comes in handy when I do.
Let ( [
~query = "
SELECT *
FROM \"TABLE\"
WHERE \"FIELD\" = ?
";
~result = ExecuteSQL ( ~query ; "" ; "" ; QUERY)
] ;
~result
)
I use this in the Data View to jumpstart my query. If I end up using the calculation in production, I’ll replace the table and field strings with references.