Supported
Which functions does FileMaker's ExecuteSQL() function support?
These are the functions we've been working with. If you find others supported, please let us know.
And
Cast
Count
GroupBy
Fetch First
From
Join
Left Join
Like
Lower
Max
Min
NOT Like
Offset
Order By
OrderBy
Select
Select Distinct
Sum
Union
Upper
Where
Cast
Count
GroupBy
Fetch First
From
Join
Left Join
Like
Lower
Max
Min
NOT Like
Offset
Order By
OrderBy
Select
Select Distinct
Sum
Union
Upper
Where
