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:
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
13.4
13.5
Statistic
FMM
Blog
Sets a string value of a specific command option.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
SQL | 2.6 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example |
---|---|---|
Command | The command reference number gained with SQL.NewCommand. | $Command |
Key | A string key of the command option. | "" |
Value | The new value. | "" |
Returns "OK" or error message.
Requests a scrollable record set:
MBS( "SQL.SetCommandOption"; $Command; "Scrollable"; "True" )
Store MySQL RecordSet locally:
MBS( "SQL.SetCommandOption"; $Command; "HandleResult"; "Store" )
Requests 100 rows to be prefetched:
MBS( "SQL.SetCommandOption"; $Command; "PreFetchRows"; "100" )
Set an option we may for ODBC to FileMaker:
MBS( "SQL.SetCommandOption"; $Command; "ODBCAddLongTextBufferSpace"; "false" )
// newer plugins automatically set it right when connecting to FileMaker
Allow multple connections for Microsoft SQL Server:
MBS( "SQL.SetCommandOption"; $Command; "SQL_ATTR_CURSOR_TYPE"; "SQL_CURSOR_DYNAMIC" )
Set option for concurrency on MS SQL Server:
MBS( "SQL.SetCommandOption"; $Command; "SQL_ATTR_CONCURRENCY"; "SQL_CONCUR_READONLY" )
# Sets the statement concurrency attribute. See SQNCLI documentation for an additional information.
# Valid values: "SQL_CONCUR_READONLY", "SQL_CONCUR_VALUES", "SQL_CONCUR_ROWVER", "SQL_CONCUR_LOCK".
This function is free to use.
Created 18th August 2014, last changed 10th January 2020