Dracoventions

An SQL statement and its results
SQL example

2empowerFM SQL Runner

SQL (Structured Query Language) is an industry standard method of reading and writing to most databases. SQL Runner gives you the power of SQL in FileMaker 7v3 and later. Now SQL queries can be run anywhere you can put a calculation: In scripts, field validations, auto-enter field values, and so on.

SQL ignores FileMaker table relationships, allowing you to read and write data in unrelated tables without changing the current record or layout. Use SQL in scripts to access an unrelated table of global configuration or status fields.

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.

All SQL plug-ins use FileMaker's built-in SQL engine, so you won't find performance or SQL feature differences among plug-ins. 2empowerFM SQL Runner comes with a competitive price and documentation describing many quirks of FileMaker's SQL engine.

System Requirements
30-Day Free Trial
Download for Windows Download for Macintosh

Latest version is 1.51, released 1/31/2010. Version History

Purchase
Licenses start at just $19.99 for a single user.

Pricing and License Options

Join the Mailing List
To be informed of product updates, submit your email using the box below. We won't share your email with anyone else or send you anything other than Dracoventions product news.
First Name: (optional)
Last Name: (optional)
Email:
Send me updates about: Mac Version Windows Version
Questions? Feedback? Bugs? Contact Us