MMQuery

Query your databases without relationships.

Functions

There are two ways to view the MMQuery function reference, the Function Reference below, and the Function Reference Browser in a new window.

Function Reference

The Function Reference is a complete reference for MMQuery functions. Click on a function title to view more information which includes the function description, parameter information, example usage and more.

Function Reference Browser

function_browser

The Function Reference Browser offers better navigation for the MMQuery functions, you can Launch Function Browser in a new window.

Function Reference

  • MMQuery_AddField

    This function Adds a new Field to an existing Table. The first parameter is the Name of a Table Occurrence of the Table to Add the new Field to. If you do not specify this parameter, MMQuery will... read more

  • MMQuery_AddRecord

    This function Adds a new Record to an existing Table. The first parameter is the Name of a Table Occurrence of the Table to receive the new Record. If you do not specify this parameter, MMQuery... read more

  • MMQuery_AddTable

    This function Adds a new Table to the current Database File. The first parameter is the Name of the new Table, which must be unique for the current Database File. The second parameter is a return-... read more

  • MMQuery_Configure

    Calling this function with no parameters will open the MMQuery Configuration Dialog. You can optionally open to a specific tab by specifying the name of the tab as the "Option" parameter. This... read more

  • MMQuery_EscapeQuotes

    This is a utility function that takes raw Text and conforms it to what the ExecuteSQL function needs in order to function correctly. It turns any Backward Slashes ( \ ) into a double-Backward Slash... read more

  • MMQuery_ExecuteSQL

    This function allows you to use SQL statements to run queries against the current Database File. If the Query you are using will be returning Field values and multiple Records, you can optionally... read more

  • MMQuery_ExecuteSQLEx

    Note: This function is only available in FileMaker Pro 11 and above. This "extended" version of MMQuery_ExecuteSQL allows you to optionally specify a separate, open Database File from the current... read more

  • MMQuery_FieldExists

    This function checks for the Existence of a Field in an existing Table. The first parameter is the Name of a Table Occurrence of the Table to look at for the Field. If you do not specify this... read more

  • MMQuery_FindRecords

    This function does a Find against a Table and returns all matches. The first parameter is the Name of the Table Occurrence to perform the Find in. If you do not specify this parameter, MMQuery will... read more

  • MMQuery_GetAsSQLDate

    This function will convert a FileMaker Pro Date value into an SQL Date Format suitable for using in an SQL... read more

  • MMQuery_GetAsSQLTime

    This function will convert a FileMaker Pro Time value into an SQL Time Format suitable for using in an SQL... read more

  • MMQuery_GetAsSQLTimestamp

    This function will convert a FileMaker Pro Timestamp value into an SQL Timestamp Format suitable for using in an SQL... read more

  • MMQuery_GetBaseTableNames

    Note: This function is only available in FileMaker Pro 11 and above. This function returns either the Base Table Name of a specific Table Occurrence or a list of "TOName=BaseTableName" pairs for all... read more

  • MMQuery_GetFieldIDs

    This function returns either the ID of a specific Field or a list of "FieldName=FieldID" pairs for all Fields in a Table. The first parameter is the Name of a Table Occurrence of the Table to return... read more

  • MMQuery_GetFieldNames

    This function returns a list of Field Names from a Table. The first parameter is the name of a Table Occurrence of the Table to return the Field Names from. If you do not specify this parameter,... read more

  • MMQuery_GetFieldTypes

    This function returns either the Field Type of a specific Field or a List of "FieldName=FieldType" pairs for all Fields in a Table. The first parameter is the Name of a Table Occurrence of the Table... read more

  • MMQuery_GetFieldValueByFind

    This function retrieves the Value of a single Field using Find Criteria. The first parameter is the Name of a Table Occurrence of the Table to Get the Field Value from. If you do not specify this... read more

  • MMQuery_GetFieldValueByID

    This function retrieves the Value of a Single Field from a Record with a specific ID. The first parameter is the Name of a Table Occurrence of the Table to Get the Field Value from. If you do not... read more

  • MMQuery_GetFMErrorText

    This function returns the Error Text associated with a FileMaker Pro error... read more

  • MMQuery_GetLayoutFieldNames

    This function returns a list of Field Names from a Layout. The first parameter is the Name of the Layout to return the Field Names from. If you do not specify this parameter, MMQuery will use... read more

  • MMQuery_GetLayoutIDs

    This function returns either the ID of a specific Layout or a list of "LayoutName=LayoutID" pairs for all Layouts in the current Database File. If you specify a Layout Name in the first parameter,... read more

  • MMQuery_GetLayoutNames

    This function returns a list of Layout Names from the current Database... read more

  • MMQuery_GetRecordData

    Note: This function is only available in FileMaker Pro 11 and above. When using the new MMQuery_ExecuteSQLEx function or the modified MMQuery_FindRecords function, you can optionally specify that... read more

  • MMQuery_GetRecordDataColumnCount

    Note: This function is only available in FileMaker Pro 11 and above. This function returns the number of Columns or Fields in the current stored Record... read more

  • MMQuery_GetRecordDataRowCount

    Note: This function is only available in FileMaker Pro 11 and above. This function returns the number of Rows or Records in the current stored Record... read more

  • MMQuery_GetTOIDs

    This function returns either the ID of a specific Table Occurrence or a list of "TOName=TOID" pairs for all Table Occurrences in the Database File. If you specify a TO Name in the first parameter,... read more

  • MMQuery_GetTONames

    This function returns a list of Table Occurrence Names from the Database File. With FileMaker Pro 11, if the optional FileName parameter is defined, this function will return a list of the Table... read more

  • MMQuery_LayoutExists

    This function checks for the Existence of a Layout in the current Database File. The parameter is the Name of the Layout to look... read more

  • MMQuery_Register

    You can use this function to Register the plug-in from a script instead of through the Configuration Dialog. This is useful when the plug-in is being distributed to many computers, allowing you to... read more

  • MMQuery_RemoveField

    This function Removes a Field from a Table. The first parameter is the Name of a Table Occurrence of the Table to Remove the Field from. If you do not specify this parameter, MMQuery will use... read more

  • MMQuery_RemoveRecordByFind

    This function Removes one or more Records based on a Find Criteria. The first parameter is the Name of a Table Occurrence for the Table to Remove the Record from. If you do not specify this... read more

  • MMQuery_RemoveRecordByID

    This function Removes a Record from a Table using its Internal FileMaker Record ID. The first parameter is the Name of a Table Occurrence of the Table to Remove the Record from. If you do not specify... read more

  • MMQuery_RemoveTable

    This function Removes the Base Table corresponding to the Table Occurrence Name you specify. The first parameter is the Name of a Table Occurrence for the Table to... read more

  • MMQuery_SetFieldValueByFind

    This function Sets the Value of a single Field using Find Criteria. The first parameter is the Name of a Table Occurrence of the Table to Set the Field Value in. If you do not specify this parameter,... read more

  • MMQuery_SetFieldValueByID

    This function Sets the Value of a single Field in a Record with a specific ID. The first parameter is the Name of a Table Occurrence of the Table to Set The Field Value in. If you do not specify this... read more

  • MMQuery_TOExists

    This function checks for the Existence of a Table Occurrence in the current Database File. The parameter is the Name of the Table Occurrence to look... read more

  • MMQuery_UpdateRecordByFind

    This function Updates one or more Records based on Find Criteria. The first parameter is the Name of a Table Occurrence of the Table to Update the Record in. If you do not specify this parameter,... read more

  • MMQuery_UpdateRecordByID

    This function Updates a Record in a Table Occurrence using its Internal FileMaker Record ID. The first parameter is the Name of a Table Occurrence of the Table to Update the Record in. If you do not... read more

  • MMQuery_Version

    This function returns the current version of MMQuery. This function is useful for testing whether or not the plug-in is installed and enabled. If you call this function and a question mark ("?") is... read more

  • MMQuery_VersionAutoUpdate

    This function returns an Auto Update friendly Version number of MMQuery. The format of this version number is always exactly 8 digits long. The first two digits represent the major version of the... read more