| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Matrix.SetValue
Sets a single value in the matrix.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Matrix | 9.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "Matrix.SetValue"; MatrixRef; Row; Column { ; Value } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| MatrixRef | The matrix reference number. | $matrix | |
| Row | The zero based row number. | 2 | |
| Column | The zero based column number. | 2 | |
| Value | The new value. | "Hello" | Optional |
Result
Returns OK or error.
Description
Sets a single value in the matrix.The original data type is retained.
Examples
Test set and get:
Set Variable [ $m ; Value: MBS ("Matrix.New"; 2; 2) ]
Set Variable [ $r ; Value: MBS( "Matrix.SetValue"; $m; 0; 0; Contacts::Company ) ]
Set Field [ Contacts::Job Title ; MBS( "Matrix.GetValue"; $m; 0; 0 ) ]
Set Variable [ $r ; Value: MBS ("Matrix.Release"; $m) ]
Sets a value:
Set Variable [ $r; Value: MBS("Matrix.SetValue"; $matrix;1;1;40) ]
See also
Blog Entries
FileMaker Magazin
This function checks for a license.
Created 8th April 2019, last changed 2nd November 2020
