MMQuery

Query your databases without relationships.

<- Back to MMQuery function list

MMQuery_RemoveRecordByID

Description

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 this parameter, MMQuery will use Get(LayoutTableName) to get the Current Layout TO to Remove the Record from. The second parameter is the Internal FileMaker Record ID of the Record you want to Remove. By default, MMQuery will check to make sure the TO Name and the Record ID you specify actually exist before attempting to Remove the Record. If you already know for sure that the TO Name and the Record ID exist, you can pass True as the third and fourth parameters. By default, MMQuery will double-check to make sure the Record was actually Removed. If you would rather the plug-in skip this step, specify True as the fifth parameter.

Return Type
Text
Format
MMQuery_RemoveRecordByID ( TOName ; FMRecID ; SkipTONameCheck ; SkipFMRecIDCheck ; SkipConfirmRemoval )
Required Parameters
  • TOName

    The Name of the Table Occurrence that contains the Record you want to Remove. Specify "" to use the Current Layout TO. In FileMaker Pro 11 and above, you can optionally specify the Database Filename (without the ".fp7" extension) containing the TO in the format "FileName.TOName".

  • FMRecID

    The Internal FileMaker Record ID of the Record to Remove.

Optional Parameters
  • SkipTONameCheck

    If True, MMQuery will not check to make sure the TO Name you specified actually exists before Removing the Record.

  • SkipFMRecIDCheck

    If True, MMQuery will not check to make sure the Record ID you specified actually exists before Removing the Record.

  • SkipConfirmRemoval

    If True, MMQuery will not double-check to make sure the Record was Removed.

Related Items
MMQuery_AddRecord, MMQuery_FindRecords, MMQuery_RemoveRecordByFind, MMQuery_UpdateRecordByFind, MMQuery_UpdateRecordByID
Examples

Example 1

Code:

MMQuery_RemoveRecordByID("MyTable"; 2 )

Result:

This would Remove the Record with the Record ID 2 from the "MyTable" Table.

Example 2

Code:

MMQuery_RemoveRecordByID("AnotherFile.MyTable"; 4 )

Result:

In FileMaker Pro 11 and above, use this form to Remove a Record from a Table Occurrence in a separate, open Database file.