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.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    Statistic    FMM    Blog  

Matrix.NewWithSQL

Execute the SQL Statement against a FileMaker database.

Component Version macOS Windows Linux Server iOS SDK
Matrix 9.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Matrix.NewWithSQL"; FileName; SQL Statement { ; Params... } )   More

Parameters

Parameter Description Example Flags
FileName The target database name. Can be empty to not limit query to one database. ""
SQL Statement SQL Statement as a Text string
Params... Optional, pass here parameters. One parameter to this function for each parameter you want to pass to the SQL statement. 123 Optional

Result

Returns matrix reference number or error.

Description

Execute the SQL Statement against a FileMaker database.
Returns a matrix reference number, so you can use functions like Matrix.Height, Matrix.Width, Matrix.GetValue and Matrix.DataType to query result. Don't forget to use Matrix.Release to release the result from memory when you are done with it.

This function takes variable number of parameters. Pass as much parameters as needed separated by the semicolon in FileMaker.
Please repeat Params parameter as often as you need.

See also

Created 8th April 2019, last changed 5th June 2021


Matrix.New - Matrix.Release

Feedback: Report problem or ask question.