SQL Explorer

Learn FileMaker SQL – Write Queries Faster

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.

Learn FileMaker SQL using FileMaker metaphors you already know. Follow along in our wizard and you’ll be writing queries against your own data: queries you can paste into your own files.

Overview

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.

For the Pros: Abstracted Queries

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.

Going Further (The Newest SQLExplorer)

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.

Saved Queries

Save, edit, and expand your queries, creating a library of those you frequently use.

Select Fields

No more typos: click the fields you'd like to query then edit your queries later once they're already working.

Test & Copy Query

See the results of your query then copy and paste it into your own file.

Getting Started & Docs

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.

Learn More

We’ve written a series of blog posts on FileMaker SQL if you’d like to dig deeper. Enjoy!

COMPANY

FOLLOW ALONG

Stay up to date with the latest news & examples from SeedCode

© 2024 SeedCode, Inc.