I am testing the use of ExecuteSQL to produce a pivot table. So far I have not been successful.
Simple SQL statements have syntax errors when it includes the "pivot(.....)" function in the statement.
Same statement tested outside FM works.
Does FM 15 support Pivot function call in SQL statements ?