|Plugin Info: 2empowerFM SQL Runner|
|Platform:||Win + Mac|
|Last Updated:||April 2013|
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 feature differences among plug-ins. 2empowerFM SQL Runner comes with a competitive price and documentation describing many quirks of FileMaker’s SQL engine.