New SQLexplorer

Jason has just completed a major new version of SQLexplorer that makes it easier for beginners and pros alike to write better queries.

If you haven’t used SQLexplorer before, it writes FileMaker SQL queries for you as you fill out a simple form using FileMaker terms your familiar with (sorts, relationships, etc). You can then test your query right in SQLexplorer before copying and pasting it into your solution. Queries are clearly commented and abstracted to survive field renaming.

I can tell you this has sped up our own work considerably as we now don’t have to think hard (and type correctly) every time we write a query.

If you’ve been using SQLexplorer for a while, checkout the screenshots to see what’s new.

SQLexplorer is still free and completely unlocked. Learn more and download the new version here:  get SQLexplorer. Jason has also recorded a great video of the new features in action.

Featured Posts

Follow Along

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

4 Comments

  • I downloaded the SQLexplorer and put it on my server. It looks really cool but is not usable with a hosted solution (way too slow to navigate steps). Maybe it was never intended to be hosted? I spent the afternoon playing with it and I really like the ideas. I may move a copy of the data to a local machine just to play with it more…

  • MARK

    Is there a SQL explorer for FM 11?

    • MARK

      Thanks, John. Unfortunately, we haven’t made the switch to 12 yet because of the backward compatibility issues, so I was hoping for a fp7 version of this file.

      • seedcode

        I hear you, but the file / technique requires 12; you could make an file that used plugins to do this in FM11, but the appearance, workflow etc of SQLExplorer would also need to be redone as that uses all new stuff in FM12. Thus we don’t have any plans to make an FM11 version. Sorry about that.

Leave a Reply

Your email address will not be published. Required fields are marked *

Check out some of our other posts ...

Suggesting Appointment Slots

Show Available Slots that Match Multiple Criteria Schedulers often look for gaps in their schedules to find the open resources for each opportunity. But sometimes,

Introducing Draft Settings Mode

Following up on this idea that people stretch themselves when they feel a little safer, we’ve been very focused on the customization experience for DayBack

New Longer Timescales for DayBack

Resource Scheduling Swimlanes You can now extend the pivoted scheduling view in DayBack to show items by week instead of solely by day. This lets

FileMaker Summer Camp – Recap

Unconference Sessions If you missed Pause in October, here’s a look at the sessions that attendees hosted. All the sessions are listed in this post

COMPANY

FOLLOW ALONG

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

© 2024 SeedCode, Inc.