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

SQL.GetParamAsText

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

Component Version macOS Windows Linux Server iOS SDK
SQL 2.6 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "SQL.GetParamAsText"; 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 text; converts if needed.
see also:
https://www.sqlapi.com/ApiDoc/class_s_a_param.html

Examples

Query value of first parameter:

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

See also

This function is free to use.

Created 18th August 2014, last changed 10th January 2020


SQL.GetParamAsPNG - SQL.GetParamAsTime