MongooseAll help topics · Link to this topic
Showing help on 'sqlite_interrupt()'
Syntax: sqlite_interrupt(INT <database handle>)This function causes any pending database operation to abort at its earliest opportunity. The programmer must be a wizard, or E_PERM is raised. E_INVARG is raised if the handle is invalid. If the operation is nearly finished when sqlite_interrupt is called, it might not have an opportunity to be interrupted and could continue to completion.
This can be useful when you execute a long-running query and want to abort it.
NOTE: As of this writing (server version 2.7.0) the @kill command WILL NOT abort operations taking place in a helper thread. If you want to interrupt an SQLite query, you must use sqlite_interrupt and NOT the @kill command.