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:
9.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
Statistic
FMM
Blog
SQL.SetClient
Assigns an DBMS client for the connection.
Component |
Version |
macOS |
Windows |
Linux |
Server |
iOS SDK |
SQL
|
2.6 |
✅ Yes
|
✅ Yes
|
✅ Yes
|
✅ Yes
|
✅ Yes
|
MBS( "SQL.SetClient"; Connection; Client )
More
MBS(
"SQL.SetClient"; /* Assigns an DBMS client for the connection. */
$Connection; /* The connection reference number gained with
SQL.NewConnection. */
$Client) /* The name of the database client to use.e.g. "SQLite" */
Less
Parameters
Parameter |
Description |
Example |
Connection |
The connection reference number gained with SQL.NewConnection. |
$Connection |
Client |
The name of the database client to use. |
"SQLite" |
Result
Returns "OK" on success.
Description
Assigns an DBMS client for the connection.
You can set a client in Connect method, in this case you don't need to use setClient method. The main destination of this method is to connect to a server with no connection to a database (for example, to check a client availability and version). But if you are calling Connect method with no specified client you have to use setClient method before.
If you are calling setClient method when the connection is set to another client the previous connection will be disconnected and new client will be set.
Pass one of this values: CubeSQL, SQLAnywhere, ODBC, Oracle, SQLServer, Firebird, InterBase, SQLBase, DB2, Informix, Sybase, MySQL, PostgreSQL or SQLite. Connect to Microsoft Access, FileMaker Server (or Pro), Microsoft Visual FoxPro and others via ODBC.
Be aware that for most database servers, you need to specify client library with SQL.SetConnectionOption first.
You don't need SQL.SetClient when you pass client to SQL.Connect and you should call SQL.SetConnectionOption before those.
Examples
Sets client to be SQLite:
MBS( "SQL.SetClient"; $Connection; "SQLite" )
Sets client to be Oracle:
MBS( "SQL.SetClient"; $Connection; "Oracle" )
See also
Example Databases
Blog Entries
FileMaker Magazin
Created 18th August 2014, last changed 4th June 2020
SQL.SetAutoCommit
-
SQL.SetCommandOption
Feedback: Report problem or ask question.