Topics
All
Mac OS X
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Guides
Examples
New in version:
8.3
8.4
8.5
9.0
9.1
9.2
9.3
9.4
9.5
10.0
Statistic
Component: Matrix
Matrix functions
Two dimensionals lists.
| Item | Details |
|---|---|
| Matrix.AddColumn Adds one column to a matrix. | All 9.2 |
| Matrix.AddColumns Adds columns to a matrix. | All 9.2 |
| Matrix.AddRow Adds a row to the matrix. | All 9.2 |
| Matrix.AddRows Adds rows to the matrix. | All 9.2 |
| Matrix.Avg Calculates average value in a matrix column. | All 9.2 |
| Matrix.CSV Queries text of matrix for CSV export. | All 9.2 |
| Matrix.Clear Clears the matrix. | All 9.2 |
| Matrix.ClearValues Clears all values in the matrix. | All 9.2 |
| Matrix.Clone Creates a copy of a matrix. | All 9.2 |
| Matrix.DataType Queries data type of a value. | All 9.2 |
| Matrix.Free Frees the matrix object. | All 9.2 |
| Matrix.GetColumn Queries text of a whole column. | All 9.2 |
| Matrix.GetRow Queries text of a whole row. | All 9.2 |
| Matrix.GetText Queries text of whole matrix. | All 9.2 |
| Matrix.GetValue Queries a single value. | All 9.2 |
| Matrix.Height Queries height of matrix. | All 9.2 |
| Matrix.InsertRecords Inserts records in FileMaker database from records in memory. | All 9.2 |
| Matrix.InsertRecordsToSQL Inserts records in SQL database from records in memory. | All 9.2 |
| Matrix.JSONRecord Returns a row as JSON object. | All 9.2 |
| Matrix.JSONRecords Returns rows as JSON array. | All 9.2 |
| Matrix.Max Queries max value in a matrix column. | All 9.2 |
| Matrix.Min Queries min value in a matrix column. | All 9.2 |
| Matrix.New Creates a new matrix (2D array). | All 9.2 |
| Matrix.NewWithSQL Execute the SQL Statement against a FileMaker database. | All 9.2 |
| Matrix.RemoveColumn Removes a column. | All 9.2 |
| Matrix.RemoveRow Removes a row. | All 9.2 |
| Matrix.Resize Resizes matrix to given height and width. | All 9.2 |
| Matrix.SetColumn Sets a column to the given texts. | All 9.2 |
| Matrix.SetRow Sets a row to the given texts. | All 9.2 |
| Matrix.SetValue Sets a single value in the matrix. | All 9.2 |
| Matrix.Sum Calculates sum value in a matrix column. | All 9.2 |
| Matrix.Text Queries text of matrix. | All 9.2 |
| Matrix.Width Queries width of matrix. | All 9.2 |
33 functions.
Release notes
- Version 9.2
- Added Matrix functions for a two dimensional list with FileMaker native data types.
Feedback: Report problem or ask question.
Links
MBS Xojo Plugins
