| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
FM.SQL.ToMatrix
Copies from result set to a Matrix.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| FM FMSQL | 14.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "FM.SQL.ToMatrix"; SQLref ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| SQLref | The reference number returned by FM.SQL.Execute function. | $SQLRef |
Result
Returns matrix reference number or error.
Description
Copies from result set to a Matrix.Allows you to do a FM.SQL.Execute, work with the result set, convert to matrix and then use matrix functions.
See also
Release notes
- Version 14.0
- Added FM.SQL.ToMatrix function.
Blog Entries
- MBS FileMaker Advent calendar - Door 4 - FM.SQL.Executeand life in the matrix
- New in MBS FileMaker Plugin 14.0
- Neues MBS Plugin 14.0 für Claris FileMaker
- MBS FileMaker Plugin 14.0 for Claris FileMaker
- MBS FileMaker Plugin, version 13.6pr1
- Data structures in MBS Plugin
This function checks for a license.
Created 24th November 2023, last changed 29th September 2025
