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

SQL.SetParamAsFloat

Sets parameter's value as floating point number.

Component Version macOS Windows Linux Server iOS SDK
SQL 2.6 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "SQL.SetParamAsFloat"; Command; Param; Value )   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"
Value The new value 123.456

Result

Returns "OK" or error message.

Description

Sets parameter's value as floating point number.
For integer numbers, please use SQL.SetParamAsNumber.

Examples

Set value for parameter with ID 5 to a floating point number:

MBS("SQL.SetParamAsFloat"; $Command; 5; $TotalSales)

Set value for parameter with name "Sales" to a floating point number:

MBS("SQL.SetParamAsFloat"; $Command; "Sales"; $TotalSales)

See also

Example Databases

This function is free to use.

Created 18th August 2014, last changed 13th January 2015


SQL.SetParamAsDateTime - SQL.SetParamAsNumber