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:
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
11.3
11.4
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".
Created 18th August 2014, last changed 10th January 2020
SQL.SetClient - SQL.SetCommandTag
Feedback: Report problem or ask question.