Requirements

Mac	10.9, 10.10, 10.11, 10.12, 10.13, 10.14, 10.15, 11.1, 11.2, 11.3, 11.4, Apple Silicon, 11.5, 11.6, 12.0, 13.0, 14.0, 15.0
Win	7, 8, 10, Microsoft Visual C++ 2017 Redistributable Package, Microsoft .NET Framework 4.7.2, 11
FileMaker Pro	14.x (32Win), 14.x (64), 15.x (32Win), 15.x (64), 16.x (32Win), 16.x (64), 17.x (32Win), 17.x (64), 18.x (32Win), 18.x (64), 19.x, 20.x, 2023, 2024, 2025, 22.x, 21.x
FileMaker Server	13.x, 14.x, 15.x, 16.x, 17.x, 18.x, 12.x, 19.x, 20.x, 2023, 2024, 21.x, 2025, 22.x

Version History

Linux Server support

Fixed a number parsing bug

Now compatible with Apple Silicon Macs

Now fully compatible with Apple Silicon based Macs
New Windows Requirements: Windows 7 and above, .NET 4.7.2, MSVC++ 2017 Redistributable
Fixed an issue where the optional TOName parameter was set to required for several functions
Updates to CNS Core

Script Steps + iOS Version + JSON + Installer

New Mac requirements: 10.9+, 64-bit only, FMP 14+
New Windows Requirements: Vista and above, .NET 4.5.x MSVC++ 2017 Redistributable
All new iOS version now included for use with the FileMaker iOS App SDK
All new installer database now provided for easy installs.
ExecuteSQL and FindRecords can now optionally return data in JSON format.
The plug-in is now signed.
The plug-in is compiled against the latest FileMaker plug-in API and makes use of new functions/features where available.
Imported tons of updates from other CNS Plug-ins (too many to mention).
Added Script Steps for FileMaker 16+.
Adds support for FileMaker 16+ instant online help feature. Just click the small question mark in a circle button located next to the script step or function descriptions.
Updated with latest CNS Core changes (too many to mention).
Other small bug fixes.

CNS Core updates (FM15 support and thread safety fixes)

Added support for FileMaker 15 plug-in features like type-ahead and calculation function completion, as well as some internal features.
Added some very important thread-safety features to make sure the plug-in runs without issues, especially under FileMakes Server.
Imported many other updates from other CNS Plug-ins.

Full, cross-platform, 64-bit GUI support + core code updates

Renamed to CNS Query + 64-bit support

Renamed the plug-in to CNS Query (from MMQuery).
Drop-in replacement for MMQuery (no need to rewrite calculations).
Added 64-bit support for FileMaker Pro and FileMaker Pro Server (including Scheduled Scripts and Web Direct).
Removed PPC support from Mac plug-in.
Includes updates and bug fixes to CNS Core code.
Fixed a bug where the whitespace was being trimmed from some results.
Fixed a bug where database, table, and field names were being compared in a case-sensitive manner.
Modified GetAsSQLDate/Time/Timestamp to only return a value if an actual date/time/timestamp value was provided, otherwise, it returns nothing at all

Bug Fixes

Fixes a bug that caused a tremendous slow down when returning large amounts of data from a query.
Fixes an issue with Developer’s License Keys not working correctly.

Maintenance Update

Plug-in core code has been completely rewritten from the ground up for speed and to take advantage of the latest operating system features.
Long-standing issue with Runtimes not closing correctly on Windows has been resolved.
The plug-in now requires .NET 3.5 on Windows.
Windows plug-in is now much smaller in size.

Maintenance Update

Imported core plug-in updates from other CNS Plug-ins.
Added a preference under FileMaker Pro 11 which makes the plug-in always use the newer SQL interface.

New FileMaker Pro 11 only Functions / Other bug fixes

Imported several updates and changes from other CNS Plug-ins.
Added CNSQuery_GetAsSQLDate, CNSQuery_GetAsSQLTime, and CNSQuery_GetAsSQLTimestamp for converting dates, times, and timestamps into a format suitable for SQL Queries.
Clarified Function and Parameter names in regards to Tables and Table Occurrences.
Added CNSQuery_ExecuteSQLEx function for FileMaker Pro 11.
Added CNSQuery_GetBaseTableNames for FileMaker Pro 11.
Added CNSQuery_GetRecordData, CNSQuery_GetRecordDataColumnCount, and CNSQuery_GetRecordDataRowCount for use with new FileMaker Pro 11 functions/features.
Updated every function that takes a Table Occurrence as a parameter to allow for specifying a different open file under FileMaker Pro 11 using the “FileName.TOName” format.
Updated the CNSQuery_FindRecords function to support the RecordData functions under FileMaker Pro 11.
Updated the CNSQuery_GetTONames function to optionally take a FileName parameter under FileMaker Pro 11.

New Server Edition / Misc. Improvements

Inital Public Release