ExecuteSQL and the having clause
Does anyone know if the having clause works with FM 12 v2 Advanced function ExecuteSQL? I have tried and it appears that it doesn't like it. :-(
I've been told by a manager at FileMaker Inc. that the documentation of the SELECT statement found in the ODBC JDBC Guide pdf that can be opened from the FielMaker Help menu is also accureate for the Execute SQL function. According to it, HAVING should work, but SQL errors inside your ExecuteSQL function call can be very frustrating to debug. Feel Free to post what you have that didn't work.
Yes can be frustrating - but thank you I found my error and HAVING does work when you have the clause correct.
Retrieving data ...