Topics
All
Mac OS X
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server (Not)
Client
Old
Guides
Examples
New in version:
6.0
6.1
6.2
6.3
6.4
6.5
7.0
7.1
7.2
7.3
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 |
MBS( "SQL.SetParamAsText"; Command; Param; Value )
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/MySQL example
- SQL to other databases/ODBC to FIleMaker/ODBC Test
- SQL to other databases/SQLite blob
- SQL to other databases/SQLite fun
SQL.SetParamAsNumber - SQL.SetParamAsTime
Feedback: Report problem or ask question.
Links
MBS Xojo blog
