Monkeybread Software - MBS FileMaker Plugin: Matrix.SetColumn

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

Matrix.SetColumn

Sets a column to the given texts.

Component	Version	macOS	Windows	Linux	Server	FileMaker 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

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" ) ]

Blog Entries

Matrix functions for FileMaker

FileMaker Magazin

Created 8th April 2019, last changed 17th December 2019

Matrix.Resize - Matrix.SetColumnName

Feedback: Report problem or ask question.