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 will not find performance or SQL feature differences among plug-ins.
SQL Runner offers you a trial period and full documentation for describing many special cases in the use of the FileMaker`s SQL engine.
· FileMaker Pro or Server 7.3 to 11
· 30 days trial
What`s New in This Release: [ read full changelog ]
· Dialogs Unlimited: Fixed dialogs sometimes appearing centered over an invisible Inspector window in Windows FileMaker 11.
· Menu Popper: Added `left` and `top` parameters to work with GetLayoutObjectAttribute() coordinates. `x` and `y` parameters will continue to work with FieldBounds() coordinates.
· Menu Popper: New documentation complete.