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


Returns param's value as integer; converts if needed.

Component Version macOS Windows Linux Server iOS SDK
SQL 2.6 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "SQL.GetParamAsNumber"; Command; Param )   More


Parameter Description Example
Command The command reference number gained with SQL.NewCommand. $Command
Param The parameter name or ID. Pass number for ID, a text with parameter name or the index with # prefix. e.g. "#0" for first parameter. "1"


Returns the value or error message.


Returns param's value as integer; converts if needed.
For float values, you can use SQL.GetParamAsFloat.

see also:

Improved for MBS Plugin version 12.0 to work for all number types and preserve numeric values.


Query value of first parameter:

MBS( "SQL.GetParamAsNumber"; $Command; "#0" )

See also

Release notes

Blog Entries

This function is free to use.

Created 18th August 2014, last changed 16th November 2021

SQL.GetParamAsJPEG - SQL.GetParamAsPDF