in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows

sqlite3_interrupt()

Last post 12-13-2007 11:59 AM by pcoffe. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-20-2007 6:56 PM

    • pcoffe
    • Top 500 Contributor
    • Joined on 11-20-2007
    • Posts 2

    sqlite3_interrupt()

    Hello,

    I'm looking for a way to cancel/interrupt a long running query.

    I found this on the sqlite website

    http://www.sqlite.org/c3ref/interrupt.html 

    although don't see it exposed in the SQLiteConnection class.

    If - as I suspect - this function isn't exposed, does anyone know of any other technique I can use?

    (bearing in mind I'm in a multithreaded environment and would like to be able to interrupt a query from a different thread.)

    Thanks. 

  • 12-13-2007 4:05 AM In reply to

    Re: sqlite3_interrupt()

    Did you find a solution, I am also looking for a way to cancel a running query?

    There is a SQLiteCommand.Cancel method but it is not implemented.

    Gavin

  • 12-13-2007 11:59 AM In reply to

    • pcoffe
    • Top 500 Contributor
    • Joined on 11-20-2007
    • Posts 2

    Re: sqlite3_interrupt()

    I haven't found a solution yet.  I put the problem on the back burner...

    The 1.1 verison of the data provider did expose the interrupt() function...which makes this all the more dissapointing!


    Paul.

Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems