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
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 |
---|---|---|---|
Hours | The hour of the day at which to call the script. | 12 | |
Minutes | The minute of the day at which to call the script. | 10 | |
Seconds | The seconds of the day at which to call the script. | 0 | |
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 |
Column Delimiter | Columns Separator, only used with SELECT statement. Default is TAB. | 9 | Optional |
Record Delimiter | Record Separator, only used with SELECT statement, Default is Return | 13 | Optional |
RepeatHour | The number of hours to wait between script calls. | 1 | Optional |
RepeatMinute | The number of minutes to wait between script calls. | 0 | Optional |
RepeatSecond | The number of seconds to wait between script calls. | 0 | 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
Schedule.ExecuteSQLAfterDelay - Schedule.ExecuteSQLAtTimeStamp