DoSQL plug-in
DoSQL plug-in
Do more with SQL in FileMaker Pro
myFMbutler DoSQL is a FileMaker Pro plug-in for Windows and Mac that allows you to manipulate FileMaker data from FileMaker calculations.
The plug-in uses SQL statements to select, update, create or delete FileMaker records.
What’s new in version 2.1?
- Faster
- New DoSQL functions with simplified syntax, allows you to query and manipulate data without any knowledge of SQL
- Returns native FileMaker data types like dates, images, formatted text, etc.
- Execute queries with parameters to prevent SQL injection.
- Functions to work with result sets
- Debug tools to help you locate SQL issues in your solution
- Compatible with FileMaker Server 12 or higher
Features
- Uses SQL statements to select, update, create or delete FileMaker records.
- Writes to FileMaker fields directly, using a calculation with SQL statements
- Does complex portal filtering
- Easily updates data in unrelated tables
- Keeps a ChangeLog of your records, add rollback functionality, audit trails, etc.
Benefits
- Limits the number of tables, relationships, fields, and scripts required for certain tasks
- Doesn’t require any drivers
- Original FileMaker data type is retained
System requirements
- FileMaker Pro 17 Advanced
- FileMaker Pro 16 or FileMaker Pro 16 Advanced
- FileMaker Pro 15 or FileMaker Pro 15 Advanced
- FileMaker Server 17
- FileMaker Server 16
- FileMaker Server 15
- Mac OS X 10.10 or higher
- Windows 7 SP1 Ultimate, Professional, Home Premium
- Windows 8.x and Windows 8.x Pro
- Windows 10.x and Windows 10.x Pro