The Compleat Idiot’s Guide To FileMaker ExecuteSQL

Not you. Us. (Well one of us anyway.)

One of our illustrious co-coordinators, Jonathan Fletcher, has been using FileMaker’s ExecuteSQL function for several years now. In fact, he traces his love for the function back to the super-helpful article that fellow-Kentuckian Beverly Voth[1] wrote for the FileMaker Hacks blog site way back in ‘12 [2].

That article has become required reading for anyone wishing to embark on a journey with the most powerful function that the FileMaker gods ever bestowed upon us mortal developers (uh, sorry, “workplace innovators”).

For the past 6 years, though, Fletcher has been evolving the techniques he uses to deploy ExecuteSQL in all manner of calculation and scripting problem solving. He admits, rather embarrassed, that he considers himself a lightweight in the worldwide FileMaker community. So he finds it quite astonishing that he has gotten pretty good at using the tool to quickly address so many of his data retrieval, formatting and processing needs.

So in awe of what it can do, he has devleloped a system of techniques that he would like to share with everyone. As alluded to above, he calls it “The Compleat Idiot’s Guide To FileMaker ExecuteSQL.”

He will walk you through the [very] basic structure of a common garden-variety SQL function, his default calculation format, supporting custom functions, and a long list of practical applications that take mere seconds to write, and save you tons of FileMaker table occurrences and scripting to get the same answer. “If I can do it, anyone can do it,” claims Fletcher.

Oh, and you’ll also learn when it is NOT a good idea to use ExecuteSQL (an equally good thing to know).

So come on out on the 25th and learn from the “Compleat Idiot” himself how to make this awesome function your own private data slave.

See you next Tuesday!

This month, our usual fourth Tuesday:
Tuesday, September 25th
12:00 – 3:00pm – BYOBB[3]

Universal Design
1234 South Third Street (in the heart of Old Louisville)

Register at http://www.kyfmp.com/reg/
Join in the discussion: sign up for our listserv at http://fmpug.com/mailman/listinfo/louisville_fmpug.com

[1] Those of you who would like to make a pilgrimage (or if you simply live further east) to learn at the feet of the SQL guru herself may participate in the group Beverly Voth leads in Lexington on the second Saturday of most months (next meeting: November 10) at 1:00 PM at the Eastside Branch of the Lexington Public Library, 3000 Blake James Dr., Lexington, KY 40509. Info at https://community.filemaker.com/thread/190579. To get on her mailing list, contact her at beverlyvoth@gmail.com

[2] https://filemakerhacks.com/2012/10/19/the-missing-fm-12-executesql-reference/

[3] BYOBB: Bring Your Own Brown Bag

Leave a Comment

You must be logged in to post a comment.