Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

FM.ExecuteSQL.LastParameters

Queries parameters from last failed SQL command.

Component Version macOS Windows Linux Server iOS SDK
FM 16.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "FM.ExecuteSQL.LastParameters" )

Parameters

none

Result

Returns JSON or error.

Description

Queries parameters from last failed SQL command.
This allows you to debug problems with MBS functions doing multi commands, so e.g. you can see which values the failed record for an insert.
When an error happens, we serialize the parameters used for the SQL operation.
Value is empty if no parameters have been recorded.

See FM.ExecuteSQL.LastSQL for the corresponding SQL statement and FM.ExecuteSQL.LastErrorMessage for the error message.

Examples

Try it:

MBS("FM.InsertRecord"; ""; "NonExistingTable"; "test"; 123; "other"; "abc") & ¶ &
MBS("FM.ExecuteSQL.LastParameters")

Example result:
[MBS] ERROR: FQL0002/(1:12): The table named "NonExistingTable" does not exist.
[123, "abc"]

See also

Release notes

  • Version 16.2
    • Added FM.ExecuteSQL.LastParameters function.

Blog Entries

This function is free to use.

Created 18th March 2026, last changed 18th March 2026


FM.ExecuteSQL.LastErrorMessage - FM.ExecuteSQL.LastSQL