SQL (Structured Query Language) is an industry-standard method of reading and writing data in databases. SQL Runner is a free FileMaker^® Pro and Server database plugin that lets you read and write data from and to FileMaker in powerful new ways.

If you're not familiar with SQL, you can find lots of information about it online, or visit w3schools for an introduction.

Access data anywhere.

SQL Runner lets you run queries anywhere you can put a calculation in FileMaker:

• In scripts
• field validations
• auto-enter field values
• and more.

Make your own relationships.

This SQL query relates a person to their address using AddressID

SQL ignores FileMaker table relationships, allowing you to read and write data in unrelated tables without moving away from the current record or layout.

Use SQL in scripts to access an unrelated table of global configuration or status fields.

Advanced validation.

One SQL statement can often do the same thing as multiple script steps. This is great for advanced field-validation calculations where a script can't be used and changing the layout or record would interrupt the validation.

Do more in FileMaker 11.

If you're using FileMaker 11 or later, your SQL queries can do even more:

• Read binary data from container fields.
• Write binary data to container fields.
• Run an SQL query in the context of any FileMaker database file.

It's free.

All FileMaker SQL plugins use FileMaker's built-in SQL engine, so you won't find performance or feature differences in how SQL queries are interpreted by different plugins. 2empowerFM SQL Runner is free and comes with documentation describing many quirks of FileMaker's SQL engine.

Download

Latest version is 2.74.
Changes in each version  |  Download previous versions

Install and Uninstall instructions  |  License agreement