Small, Fast, Reliable.
Choose any three.

SQLite C Interface

Interrupt A Long-Running Query

void sqlite3_interrupt(sqlite3*);

This function causes any pending database operation to abort and return at its earliest opportunity. This routine is typically called in response to a user action such as pressing "Cancel" or Ctrl-C where the user wants a long query operation to halt immediately.

It is safe to call this routine from a thread different from the thread that is currently running the database operation. But it is not safe to call this routine with a database connection that is closed or might close before sqlite3_interrupt() returns.

The SQL operation that is interrupted will return SQLITE_INTERRUPT. If an interrupted operation was an update that is inside an explicit transaction, then the entire transaction will be rolled back automatically.

See also lists of Objects, Constants, and Functions.


This page last modified 2007/11/22 00:41:31 UTC