Topics
All
Mac OS X
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server (Not)
Client
Old
Guides
Examples
New in version:
6.5
7.0
7.1
7.2
7.3
7.4
7.5
8.0
8.1
8.2
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 )
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" |
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" )
See also
FM.UpdateRecords - FM.UpdateRecords3
Feedback: Report problem or ask question.
Links
MBS Xojo Plugins