Hi everyone,
How can I use LIMIT 1 in SQL explorer?

Code: Select all

SELECT *
FROM "Booking" a
INNER JOIN "System" b ON a."cnTourTypeID" = b."_kfgnTourTypeID"
WHERE a."_kfnTourID" = ? AND a."_kfdTourDate" = ? LIMIT 1

GROUP BY also seems to be not working.

FileMaker doesn't support Limit, unfortunately, but you can use Fetch First as described here: https://www.seedcode.com/filemaker-13-sql/ (More here: http://help.filemaker.com/app/answers/d ... executesql )

Group By is supported by FileMaker but is not expressed in SQLexplorer's interface. You can, or course, edit the SQL directly as Jason described in "Going Further" and get things like Group By working once you have the syntax right.

Hope that helps.