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
- SQL.Execute
- SQL.GetParamAsJPEG
- SQL.GetParamAsPDF
- SQL.GetParamAsPNG
- SQL.GetParamAsTime
- SQL.GetParamIsNull
- SQL.SetParamAsDate
- SQL.SetParamAsFloat
- SQL.SetParamAsText
- SQL.SetParamAsTime
This function is free to use.
Created 18th August 2014, last changed 10th January 2020