MMQuery is a great FileMaker plug-in that provides the user with many easy-to-use functions to work with data from any calculation without generating any extraneous relationships.
You can add, remove, and update tables, fields, and records. Get or Set the value of any field by name. Extract information about fields like name, id, and type.
Extract information about layouts like name, id, and what fields are on the layout. Check whether a field, layout, or table exists. List and concatenate information from one or more fields from any table without defining a relationship to that table. We have even provided a function for direct SQL access if you are fluent in SQL.
Here are some key features of "MMQuery":
· FileMaker Pro 11 adds an entirely reworked internal SQL Engine which allows FileMaker Pro plug-ins to interact with it in new and exciting ways. There are several new functions and features in MMQuery when it is used with FileMaker Pro 11. (These functions and features will not be visible when the plug-in is used with any version before FileMaker Pro 11.)
· MMQuery_ExecuteSQLEx - This "extended" version of the ExecuteSQL function adds the ability to run your query against any table in any open file (not just the current file). It also has the ability to store the results internally to be retrieved individually for each cell. Finally, it allows you to use "SQL Parameters" (question marks in your SQL query) and provide those parameters to the function to do things like set stored container fields.
· MMQuery_GetBaseTableNames - Returns the Base Table Name of any given Table Occurrence or all Table Occurrences.
· MMQuery_GetRecordData - Allows you to retrieve any cell of data from a previous call to ExecuteSQLEx or FindRecords.
· MMQuery_GetRecordDataColumnCount - Returns the number of columns in the current stored record data.
· MMQuery_GetRecordDataRowCount - Returns the number of rows in the current stored record data.
· Functions which accept a TOName - Any function which accepts a Table Occurrence Name can now also accept a FileName for querying a separate open file. The form is "FileName.ToName". For example, adding a text field to a table in a different file looks like MMQuery_AddField( "SomeOtherFile.MyTable" ; "MyNewField" ). (Note: When specifying the file name, do not include the ".fp7" file extension.)
· MMQuery_FindRecords - This function has a new parameter for specifying that the results be stored and later retrieved with the MMQuery_GetRecordData function.
· MMQuery_GetTONames - This function now allows for retrieving the Table Occurrence Names from any open file.
Existing Features:
· Add Tables, Fields, and Records
· Remove Tables, Fields, and Records
· Update Records
· Check for the existence of Tables, Fields, and Layouts
· List and concatenate values from fields in any table without creating relationships
· Extract Field IDs, Names, and Types
· Get and Set Field Values by name
· Extract Layout IDs, Names, and Fields
· Extract Table IDs, and Names
Requirements:
· FileMaker 7 or later
What`s New in This Release: [ read full changelog ]
· 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.
