Page Overview

• Description
• Features
• 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. We have even provided a function for direct SQL access if you are fluent in SQL. So if you are ready to have access to your data like never before, download MMQuery today and begin your adventure.

MMQuery Features:

• Add and Remove individual fields to existing tables.
• Add and Remove whole tables.
• Get or Set values from fields specifying the field names dynamically.
• Update one or more records specifying the values for one or more fields.
• Extract Table, Field, and Layout information in name=value pairs for easy querying.
• Use SQL statements to query your database.

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

Choose a function... MMQuery_AddField MMQuery_AddRecord MMQuery_AddTable MMQuery_EscapeQuotes MMQuery_ExecuteSQL MMQuery_FieldExists MMQuery_FindRecords MMQuery_GetFieldIDs MMQuery_GetFieldNames MMQuery_GetFieldTypes MMQuery_GetFieldValueByFind MMQuery_GetFieldValueByID MMQuery_GetFMErrorText MMQuery_GetLayoutFieldNames MMQuery_GetLayoutIDs MMQuery_GetLayoutNames MMQuery_GetTableIDs MMQuery_GetTableNames MMQuery_LayoutExists MMQuery_Register MMQuery_RemoveField MMQuery_RemoveRecordByFind MMQuery_RemoveRecordByID MMQuery_RemoveTable MMQuery_SetFieldValueByFind MMQuery_SetFieldValueByID MMQuery_ShowConfigDialog MMQuery_TableExists MMQuery_UpdateRecordByFind MMQuery_UpdateRecordByID MMQuery_Version