This content has been marked as final. Show 2 replies
SQL calls via the plugin API cause a memory leak when the query includes brackets
Using either ExecuteSQL or ExecuteFileSQL to run a query which includes brackets to indicate precedence results in a memory leak. Eventually this causes FileMaker Pro to crash.
Run a query such as "SELECT * FROM "MyTable" WHERE ( "Field1" = '1' AND "Field2" = '2')" against either of the plugin API functions.
The result and an increase in memory usage that is never recovered.
Don't use brackets. This often means using multiple queries which can be incredibly inefficient.