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:
9.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
Statistic
FMM
Blog
Sets parameter's value as character string data.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
SQL | 2.6 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
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 | "Hello World" | |
Type | Available in MBS FileMaker Plugin 10.3 or newer. The data type to use internally. Can be "Text", "CLob" or "LongChar". Should only be need for databases, who need the field type and data type to match exactly. e.g. Informix Default is text. |
"Text" | Optional |
Returns "OK" or error message.
Set parameter with ID = 1 to text
MBS("SQL.SetParamAsText"; $Command; 1; $FirstName)
Set parameter Lastname with text:
MBS("SQL.SetParamAsText"; $Command; "Lastname"; $LastName)
Set Param with index 0 to FirstName field:
MBS("SQL.SetParamAsText"; $Command; "#0"; SQLite fun::FirstName)
Created 18th August 2014, last changed 15th June 2020
SQL.SetParamAsNumber - SQL.SetParamAsTime
Feedback: Report problem or ask question.