| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Matrix.SetColumn
Sets a column to the given texts.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Matrix | 9.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "Matrix.SetColumn"; MatrixRef; Column { ; Values } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| MatrixRef | The matrix reference number. | $matrix | |
| Column | The zero based column number. | 2 | |
| Values | The list of values. | "1¶2" | Optional |
Result
Returns OK or error.
Description
Sets a column to the given texts.If less values are given, the other values in the column are filled with empty values.
Examples
Creates matrix and sets columns:
Set Variable [ $matrix; Value: MBS("Matrix.New";3;3) ]
# Set the values of the matrix
Set Variable [ $r; Value: MBS( "Matrix.SetColumn"; $matrix; 0;"15¶07¶92" ) ]
Set Variable [ $r; Value: MBS( "Matrix.SetColumn"; $matrix; 1;"17¶3¶60" ) ]
Set Variable [ $r; Value: MBS( "Matrix.SetColumn"; $matrix; 2;"15¶1¶87" ) ]
See also
- Matrix.AddColumn
- Matrix.CopyColumn
- Matrix.DataType
- Matrix.GetColumnNames
- Matrix.GetText
- Matrix.GetValue
- Matrix.SetColumnName
- Matrix.SetColumnNames
- Matrix.SetValue
- Matrix.Sum
Release notes
- Version 12.5
- Added Matrix.SetColumnNames and Matrix.SetRowNames functions.
Blog Entries
FileMaker Magazin
This function checks for a license.
Created 8th April 2019, last changed 17th December 2019
