May 29, 2012 in FileMaker (E)
[prMac.com] Seattle, Washington - The new ExecuteSQL calculation function in FileMaker 12 is a game changer. And if you're new to writing SQL queries, we have just what you need. SeedCode has released a free, unlocked utility to help you write the SQL queries you need to really take advantage of FileMaker 12. And, best of all, you can write these without knowing any SQL--by using FileMaker metaphors you already know, things like Relationships, Search, Sort, etc.
We've been using this tool internally for a while now to get our own queries written faster (and error free). Jason Young, the author of SQLexplorer has done a great job documenting each step of creating queries, providing detailed videos as you go. We think you'll really find this useful.
* Create and save your own library of queries
* Run queries against your own data and export the results to Excel
* Copy your queries in FileMaker's ExecuteSQL syntax so they can be pasted as-is into your own calcs
* Build queries with the explorer's wizard, then edit the resulting queries directly as you get the hang of it
SQLexplorer is completely free to you to modify and extend; it requires FileMaker Pro 12 or the latest version of FileMaker Go.
SeedCode has been building FileMaker calendars since 2001 and is recognized as a leader in design, documentation, and development best practices. SeedCode's John Sindelar is a returning DevCon speaker and one of the organizers of Pause on Error. He received the 2004 FileMaker Excellence Award for 'Developing Outstanding Technical Resources for the FileMaker Pro Community' and SeedCode Calendar was awarded the FileMaker Excellence Award for 'Solution of the Year' in 2010. Copyright (C) 2012 SeedCode. All Rights Reserved. Apple, the Apple logo, iPhone, iPod and iPad are registered trademarks of Apple Inc. in the U.S. and/or other countries.