SQL.SetParamAsText

Sets parameter's value as character string data.

Parameters

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

Result

Returns "OK" or error message.

Description

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.GetParamAsDate
• SQL.GetParamAsFloat
• SQL.GetParamAsPNG
• SQL.GetParamAsTime
• SQL.GetParamsAsJSON
• SQL.GetParamValueList
• SQL.NewCommand
• SQL.NewConnection
• SQL.SetParamAsFloat
• SQL.SetParamAsTime

Release notes

• Version 10.3
  • Added type parameter for SQL.SetParamAsText function to pick text, CLob or LongChar as type.

Example Databases

• SQL to other databases/MySQL example
• SQL to other databases/ODBC to FIleMaker/ODBC Test
• SQL to other databases/PostgreSQL Query
• SQL to other databases/SQLite blob
• SQL to other databases/SQLite fun

Blog Entries

• Insert and return new record ID
• Transactions with SQL functions
• Connect to an external database server in FileMaker
• MBS FileMaker Plugin, version 10.3pr4
• Tip of the day: Connect to MySQL and run a query

This function is free to use.

Created 18th August 2014, last changed 15th June 2020

SQL.SetParamAsNumber - SQL.SetParamAsTime