Page Overview

• Description
• Features
• Documentation
• Examples
• Functions

Description

While we were developing CNS Audit, we created several internal helper functions for running queries against FileMaker® Pro databases. We needed the ability to Add Tables; Find, Add, and Update Records; match Table, Layout, and Field names to their internal IDs; and many other things. After a while, we took a step back and thought, "we could make a plug-in out of these helper functions." MMQuery was born.

This plug-in provides you with many easy-to-use functions to work with your data from any calculation and without creating 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.

MMQuery will also run on your FileMaker Server. The Server Edition can be installed on FileMaker Server to be used with Scheduled Scripts and/or FileMaker Server Advanced to be used with Web Publishing. For more information about the Server Edition of MMQuery, please see the ReadMe file included in the MMQuery Server Edition download.

So, if you are ready to have access to your data like never before, download MMQuery today and begin your adventure!

MMQuery Features:

New for FileMaker® Pro 11: 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

Documentation

You can find the MMQuery documentation here

Examples

You can find MMQuery examples on our Example Library website.

MMQuery Functions (Choose a function below or Launch the "Function Browser")

Choose a function... MMQuery_AddField MMQuery_AddRecord MMQuery_AddTable MMQuery_Configure MMQuery_EscapeQuotes MMQuery_ExecuteSQL MMQuery_ExecuteSQLEx MMQuery_FieldExists MMQuery_FindRecords MMQuery_GetAsSQLDate MMQuery_GetAsSQLTime MMQuery_GetAsSQLTimestamp MMQuery_GetBaseTableNames MMQuery_GetFieldIDs MMQuery_GetFieldNames MMQuery_GetFieldTypes MMQuery_GetFieldValueByFind MMQuery_GetFieldValueByID MMQuery_GetFMErrorText MMQuery_GetLayoutFieldNames MMQuery_GetLayoutIDs MMQuery_GetLayoutNames MMQuery_GetRecordData MMQuery_GetRecordDataColumnCount MMQuery_GetRecordDataRowCount MMQuery_GetTOIDs MMQuery_GetTONames MMQuery_LayoutExists MMQuery_Register MMQuery_RemoveField MMQuery_RemoveRecordByFind MMQuery_RemoveRecordByID MMQuery_RemoveTable MMQuery_SetFieldValueByFind MMQuery_SetFieldValueByID MMQuery_TOExists MMQuery_UpdateRecordByFind MMQuery_UpdateRecordByID MMQuery_Version MMQuery_VersionAutoUpdate