Cancel long sqlite query via UniDac

[sandy771]

I have an application where users can create their own queries using complex joins. Occasionally someone will create a query that is too complex (a Cartesian join) so I would like an option to allow them to cancel the current query if it is taking too long to process.

I am using UniDac but (at the moment) only using SQLite and only perform queries that return datasets, I do not update or change any data.

I see that sqlite provide an sqlite3_interrupt() routine that would seem to do exactly what I need.

so can I cancel a UniQuery “select * from “ via UniDac ?

Thanks

[AlexP]

Hello,


sqlite3_interrupt stops any operation, not only query execution. Currently, UniDAC doesn't support such functionality. You can add feature suggestions at our UserVoice page: https://devart.uservoice.com/forums/104 ... components
If your idea gets enough votes, we will implement it.