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.4
7.5
8.0
8.1
8.2
8.3
8.4
8.5
9.0
9.1
Statistic
SQL.SetParamAsText
Sets parameter's value as character string data.
Component | Version | macOS | Windows | Server | FileMaker Cloud | FileMaker iOS SDK |
SQL | 2.6 | Yes | Yes | Yes | Yes | Yes |
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 | "Hello World" |
Result
Returns "OK" or error message.
Description
Sets parameter's value as character string data.Examples
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)
See also
- SQL.Connect
- SQL.GetParamAsDate
- SQL.GetParamAsFloat
- SQL.GetParamAsJPEG
- SQL.GetParamAsPDF
- SQL.GetParamAsPNG
- SQL.GetParamAsText
- SQL.GetParamAsTime
- SQL.GetParamNameList
- SQL.GetParamValueList
- SQL.NewCommand
- SQL.NewConnection
- SQL.SetParamAsContainer
- SQL.SetParamAsDate
- SQL.SetParamAsFloat
- SQL.SetParamAsTime
Example Databases
- SQL to other databases/ODBC to FIleMaker/ODBC Test
- SQL to other databases/SQLite fun
- SQL to other databases/SQLite blob
- SQL to other databases/MySQL example
Blog Entries
Created 18th August 2014, last changed 13th January 2015
SQL.SetParamAsNumber - SQL.SetParamAsTime
Feedback: Report problem or ask question.
Links
MBS Xojo blog