One of the less obvious, but exciting new features in FileMaker 13 is the two new clauses available in FileMaker’s SQL syntax. It’s less obvious, because you need to read the new FileMaker SQL Reference Guide to see they’ve been added.

Jason’s swapping out the results portal in our free SQL Explorer with a webviewer so he can take advantage of column resizing and other UI goodies you just don’t see in FileMaker. The second part of the video shows how he lets users easily swap out the styles used in the “portal” as [...]

I have one thing (at least) to follow up with on my ExecuteSQL using the Found Set post from a little bit back. This was to see if I could get the RecordID parsing optimized (or at least faster) using some of the techniques in [...]

I spent some time this weekend doing some old fashioned FileMaker hacking that I’ve always enjoyed (viva La WorkAround Pro). Definitely inspired by Todd Geist’s very cool hyper-list stuff, but he had also reminded me of the problem of ExecuteSQL on the found set, and I’ve heard this as a common feature request. [...]

I’ve had some small pre-FileMaker experience with SQL and had it in my head that subqueries work in the FROM clause. They do in MySQL etc, so I was frustrated when I couldn’t get that to work in FileMaker’s SQL as it’s really needed in some cases.

“I love SQL, love that it’s as old as relational databases, sort of Codd’s afterthought. It’s like Freud, after describing his entirely new model of the universe, added a coda, psychoanalysis, for putting it to use. Except SQL is free and it works.”

Very proud to have shipped SQL Explorer, a tool for learning SQL (so you can use ExecuteSQL in FileMaker 12) using FileMaker metaphors you already know. You can learn more about the Explorer and download a copy here: SQLexplorer But I wanted to take a moment and point out three things that make [...]

Need Help?

Download

DayBack's 30-day trial is unlocked so you can customize it and integrate it with your files.
Download DayBack and we'll send you a couple short emails with tips on how to modify it and use some of the coolest features.