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, CNS Query 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, CNS Query 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, CNS Query 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.

SkipTONameCheck

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

SkipFMRecIDCheck

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

SkipConfirmRemoval

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

Example 1

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

CNSQuery_RemoveRecordByID( "MyTable" ; 2 )

---

Example 2

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

CNSQuery_RemoveRecordByID( "AnotherFile.MyTable" ; 4 )