Matrix.GetRow

Queries text of a whole row.

Parameters

Parameter	Description	Example	Flags
MatrixRef	The matrix reference number.	$matrix
Row	The zero based row number.	2
NewLineReplacement	The replacement text for newline characters.	", "	Optional

Result

Returns list or error.

Description

Examples

Queries row values:

Set Variable [ $row ; Value: MBS("Matrix.getRow"; $Matrix;0) ]

Query columns and rows with replacing new line characters:

# query a few fields in a table
Set Variable [ $m ; Value: MBS( "Matrix.NewWithSQL"; ""; "SELECT Vorname, Comment FROM Kontakte" ) ]
#
# query columns and rows and replace new lines
Set Variable [ $col1 ; Value: MBS( "Matrix.GetColumn"; $m; 0; "-") ]
Set Variable [ $col2 ; Value: MBS( "Matrix.GetColumn"; $m; 1; "-") ]
Set Variable [ $row1 ; Value: MBS( "Matrix.GetRow"; $m; 0; "-") ]
#
# show results
Show Custom Dialog [ "First Column" ; $col1 ]
Show Custom Dialog [ "Second column" ; $col2 ]
Show Custom Dialog [ "First Row" ; $row1 ]
Set Variable [ $r ; Value: MBS( "Matrix.Release"; $m ) ]

See also

• Matrix.AddRow
• Matrix.GetColumn
• Matrix.GetRowNames
• Matrix.GetValue
• Matrix.New
• Matrix.NewWithSQL
• Matrix.Release
• Matrix.SetColumnNames
• Matrix.SetRow
• Matrix.SetRowName

Release notes

• Version 12.2
  • Added new parameter to replace new lines in the list with replacement text for Matrix.GetColumn, Matrix.GetRow and Matrix.GetText functions.

Blog Entries

• CSV in FileMaker with MBS FileMaker Plugin
• MBS FileMaker Plugin, version 12.2pr5
• Import CSV with Matrix functions

This function checks for a license.

Created 8th April 2019, last changed 9th October 2022

Matrix.GetColumnNames - Matrix.GetRowName