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

SQL.GetParamAsNumber

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

Parameters

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"

Result

Returns the value or error message.

Description

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

see also:
https://www.sqlapi.com/ApiDoc/class_s_a_param.html

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

Examples

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