SQLite3 COM Interrupt
 
Interrupt method 

Interrupts and database operations in progress. Makes sense if called from different thread.

Syntax:

object.Interrupt

Examples:

' Assume the SQLite COM is kept in an Application variable
Application("DB").Interrupt

Remarks:

As an embedded database engine SQLite executes the tasks  in the same thread from which the Execute method has been called. Therefore there will be no chance to call Interrupt with any effect over the just started operation from the same thread - the Execute will return when the work is done. however you can call it from another thread. For example in an ASP/ALP application you may have a frameset where on of the pages may cause troubles by executing a query that requires too much time. Another page in another frame may have a code that allows the user to call Interrupt from it and thus stop an operation started in the other page a mistake.

Applies to: SQLite3 COM object

See also: Execute

Supported on:

Windows 95/NT and later
Windows CE 3.0 and later
Pocket PC/Windows Mobile 2003 and later
Windows CE.NET 4 and later

 

newObjects Copyright 2001-2006 newObjects [ ]