Re: [sqlite] Re: Terminating long query in C ?

2006-10-10 Thread Doug Currie
erhead should be very small. e > - Original Message - > From: "Igor Tandetnik" <[EMAIL PROTECTED]> > To: "SQLite" <sqlite-users@sqlite.org> > Sent: Wednesday, October 11, 2006 8:43 AM > Subject: [sqlite] Re: Terminating long query in C ? &g

Re: [sqlite] Re: Terminating long query in C ?

2006-10-10 Thread Mohd Radzi Ibrahim
s@sqlite.org> Sent: Wednesday, October 11, 2006 8:43 AM Subject: [sqlite] Re: Terminating long query in C ? [EMAIL PROTECTED] wrote: sqlite3_interrupt() has long been used by the sqlite3 shell program. When you press control-C a posix signal handler invokes sqlite3_interrupt() to stop the

[sqlite] Re: Terminating long query in C ?

2006-10-10 Thread Igor Tandetnik
[EMAIL PROTECTED] wrote: sqlite3_interrupt() has long been used by the sqlite3 shell program. When you press control-C a posix signal handler invokes sqlite3_interrupt() to stop the current query. (This only works on posix, of course.) The original purpose of sqlite3_interrupt() was to support

[sqlite] Re: Terminating long query in C ?

2006-10-10 Thread Igor Tandetnik
Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote: How do I cancel a long running query? There are two ways I know of. You can register a progress handler - see sqlite3_progress_handler. The handler is called periodically while the query is running, and has the option to interrupt the query.