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: 10.5   11.0   11.1   11.2   11.3   11.4   11.5   12.0   12.1   12.2    Statistic    FMM    Blog  

Matrix.GetRow

Queries text of a whole row.

Component Version macOS Windows Linux Server iOS SDK License
Matrix 9.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes Paid
MBS( "Matrix.GetRow"; MatrixRef; Row { ; NewLineReplacement } )   More

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 text or error.

Description

Queries text of a whole row.
Returns list of values.

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

Release notes

Blog Entries

Created 8th April 2019, last changed 2nd May 2022


Matrix.GetColumnNames - Matrix.GetRowName

Feedback: Report problem or ask question.


Start Chat