Hi,
I've just started using SQLite and having come from another dbms environment I'm trying to find out if some of the features that I'm used to using in my coding are available with Sqlite. I've done a lot of searching through the documentation and I apologise if the information is there but I couldn't find it. 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. The main need for this is so that my user has a chance to cancel the processing should they want to. 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? So if my Update command changes 57 rows, then can I find that '57' number anywhere? Cheers, Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: <http://www.ward-analytics.com> http://www.ward-analytics.com Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United Kingdom, GU1 3SR Registered company number: 3917021 Registered in England and Wales. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
