Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
Runs a SQL query in any open FileMaker file.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
Schedule | 5.2 | ✅ Yes | ✅ Yes | ❌ No | ❌ No | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
TimeStamp | The timestamp at which to call the script. Plugin checks regularly if time stamp is reaches and calls as soon as current time is greater or equal the given timestamp. So calls can be delayed if FileMaker is busy! | Get(CurrentTimeStamp)+60 | |
FileName | The target database name. Can be empty to not limit query to one database. | "" | |
SQL Statement | SQL Statement as a Text string | ||
ScriptFileName | The name of the file that contains the script to be run. | Get(Filename) | Optional |
ScriptName | The exact name of the script to run | "TestScript" | Optional |
RepeatDelay | The number of seconds after which to repeat the script call. | 30 | Optional |
Params... | Optional, pass here parameters. One parameter to this function for each parameter you want to pass to the SQL statement. | 123 | Optional |
Returns reference number or error.
This function checks for a license.
Created 21st May 2015, last changed 5th June 2021