Can I use LIMIT in SQL Explorer?

General support questions.
Posts: 1
Joined: Thu Jan 05, 2017 7:37 am
PostPosted: Sun Jan 08, 2017 10:31 am
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.
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Sun Jan 08, 2017 2:20 pm
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.
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: