Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5    Statistic  

SQL.SetParamAsFloat

Sets parameter's value as floating point number.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
SQL 2.6 Yes Yes Yes Yes Yes
MBS( "SQL.SetParamAsFloat"; Command; Param; Value )   More

Parameters

Parameter Description Example value
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