Monkeybread Software - MBS FileMaker Plugin: FM.UpdateRecords2

Topics All Mac OS X (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Guides Examples
New in version: 7.3 7.4 7.5 8.0 8.1 8.2 8.3 8.4 8.5 8.6 Statistic

FM.UpdateRecords2

Updates existing records in a table in one line.

Component	Version	macOS	Windows	Server	FileMaker Cloud	FileMaker iOS SDK
FM	8.0	Yes	Yes	Yes	Yes	Yes

MBS( "FM.UpdateRecords2"; FileName; TableName; IDField1; IDValue1; IDField2; IDValue2; FieldName; FieldValue ) More

Parameters

Parameter Description Example value

FileName The file name of where the table is inside. Can be empty to look for the table in all files. Get(FileName)

TableName The name of the table to insert record into. "Assets"

IDField1 The name of the field which provides an unique ID for each record, so we can identify the field. "ID1"

IDValue1 The value for the ID field to identify the record.
Data type of parameter must match the data type of the field. $RecordID

IDField2 The name of the field which provides an unique ID for each record, so we can identify the field. "ID2"

IDValue2 The value for the ID field to identify the record.
Data type of parameter must match the data type of the field. $RelatedRecordID

FieldName A field name to set. "Model"

FieldValue A field value to use for setting the field in the parameter before.
Data type of parameter must match the data type of the field. "Test"

Parameter	Description	Example value
FileName	The file name of where the table is inside. Can be empty to look for the table in all files.	Get(FileName)
TableName	The name of the table to insert record into.	"Assets"
IDField1	The name of the field which provides an unique ID for each record, so we can identify the field.	"ID1"
IDValue1	The value for the ID field to identify the record. Data type of parameter must match the data type of the field.	$RecordID
IDField2	The name of the field which provides an unique ID for each record, so we can identify the field.	"ID2"
IDValue2	The value for the ID field to identify the record. Data type of parameter must match the data type of the field.	$RelatedRecordID
FieldName	A field name to set.	"Model"
FieldValue	A field value to use for setting the field in the parameter before. Data type of parameter must match the data type of the field.	"Test"

Result

Returns OK or error.

Description

Updates existing records in a table in one line.
Same as FM.UpdateRecords, but with two key fields.
Same as FM.UpdateRecord2, but changes multiple records.

Examples

Update record with two key fields:

MBS( "FM.UpdateRecords2"; Get(FileName); "Kontakte";
"Vorname"; "Joe"; // first key
"Nachname"; "Miller"; // second key
"Firma"; "Test Company" )

Blog Entries

MBS FileMaker Plugin, version 7.6pr1

Created 3th December 2017, last changed 5th December 2017

FM.UpdateRecords - FM.UpdateRecords3