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
Sends a query to a Serversocket on another FileMaker instance.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
ServerSocket | 3.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example |
---|---|---|
Target | The target IP or name of the server. Can be an IP or a name. | "localhost" |
Port | The network port of the server to use. | 9000 |
Login | The login secret. Server will only answer if the logins match. | "Hello" |
Type | The type of the query. Can be MBSVersion, SQL, Evaluate or Script. | "Evaluate" |
Query | The query to use. Must match the type of query above. For Script calls please use filename:scriptname:parameter to run a script and use full file name with extension. |
"Get(AccountName)" |
Returns result or error.
Query a table with SQL:
MBS( "ServerSocket.SendQuery"; "FrontDeskMac.local"; 9000; "mysecret"; "SQL"; "SELECT JobID, Status FROM JobTable" )
Query the account name of the current user:
MBS( "ServerSocket.SendQuery"; "FrontDeskMac.local"; 9000; "mysecret"; "Evaluate"; "Get(AccountName)" )
Start a script:
MBS( "ServerSocket.SendQuery"; "FrontDeskMac.local"; 9000; "mysecret"; "Script"; "OrderDatabase:PrintLastOrder:5" )
Created 18th August 2014, last changed 31st October 2016
ServerSocket.GetAllowedTypes - ServerSocket.SetAllowedScripts
Feedback: Report problem or ask question.