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.