mORMot Open Source

amsdev

Member

Registered: 2011-09-16

Posts: 23

Abort long running sqlite query

Hi,

Please can you add support of sqlite function: sqlite3_interrupt
https://www.sqlite.org/c3ref/interrupt.html

Without this function it's not possible to abort long queries performed in threads via TSQLDBSQLite3ConnectionProperties.

Or maybe I missing something ?

edwinsn

Member

Registered: 2010-07-02

Posts: 1,215

Re: Abort long running sqlite query

First time heard of the `sqlite3_interrupt` function, it seems to be very helpful!

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,324

Website

Re: Abort long running sqlite query

It is included in mORMot 2.

Upgrade to mORMot 2 if you can.

amsdev

Member

Registered: 2011-09-16

Posts: 23

Re: Abort long running sqlite query

I can't (

I use parts of your great framwork in C++Builder (after some changes I have to build most sqlite related parts for BCB), but I can't build moromot2 because of to many compiler issues. I will try to port sqlite3_interrupt from mormot2 to mormot1 myself...