David Wellman wrote: > Q1) Is it possible to execute sql commands asynchronously ? i.e. my program > issues the sql command and then 'loops' whilst waiting for the command to > finish.
No; SQLite runs neither on a separate server nor in a separate process/ thread. SQLite is a library that runs as part of your process. > The main need for this is so that my user has a chance to cancel the > processing should they want to. For that, you can install a progress handler: <http://www.sqlite.org/c3ref/progress_handler.html> > Q2) For sql commands that do not return any data (really just the DML > commands Update, Delete and Insert/Select) is there any way to find out how > many rows were affected by the command? <http://www.sqlite.org/c3ref/changes.html> Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users