SQLexplorer lets you use FileMaker metaphors you already know, like Relationships, Search, Sort, and more, to write sophisticated SQL queries.
SQLexplorer lets you use FileMaker metaphors you already know, like Relationships, Search, Sort, and more, to write sophisticated SQL queries. You can then copy and paste the resulting queries right into your FileMaker 12 files with all the correct calculation syntax. Follow our simple SQL Wizard to create and test SQL queries against your own data.
Jason Young, the author of SQLexplorer has done a great job documenting each step of creating queries, providing detailed videos as you go. We’ve been using this tool internally for a while now to get our own queries written faster (and error free). We think you’ll really find this useful.
The latest explorer (March 1, 2013) lets you copy abstracted queries to your clipboard: these are less verbose and survive field renaming, so if you’re past learning SQL, this option is for you.
Jason has added a lot of refinements to the new SQLexplorer–stuff the pros will really like–while adding a whole new way of refining queries for those of us not adept and stringing “And” clauses together.
This version uses jQuery and HTML5 for displaying query results and you’ll love what this lets you do.
Save, edit, and expand your queries, creating a library of those you frequently use.
No more typos: click the fields you'd like to query then edit your queries later once they're already working.
See the results of your query then copy and paste it into your own file.
To start using the explorer you can jump right in by tweaking the queries it comes with. To get the most out of it, though, add table occurrences from your own files to the graph and you’ll be able to query your own data right in the explorer.
SQLexplorer is completely free to you to modify and extend; if you distribute it, please keep the attribution to SeedCode and our logo on the Queries layout.
Check out the docs to learn more.
We’ve written a series of blog posts on FileMaker SQL if you’d like to dig deeper. Enjoy!
Stay up to date with the latest news & examples from SeedCode
© 2023 SeedCode, Inc.