Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.0   10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3    Statistic    FMM    Blog  

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

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


SQL.SetParamAsDateTime - SQL.SetParamAsNumber

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins

Start Chat