On Tue, Dec 28, 2010 at 5:37 AM, BareFeetWare <list....@barefeetware.com>wrote:
> . I want the SQL to take care of the commit/rollback decision so I can just > give SQLite a transaction block that will work as a whole or else just > rollback and have no effect. Then I can send that SQL transaction block via > whatever SQLite front end (eg the sqlite3 command line) I like, so it's > portable. > Hmm, I thought that for semicolon-delimited statements you have to iterate, either with your own full steps or with sqlite3_exec loop (with an exception of trigger syntax). So either way SQLite knows only about the query currently executing. So when you tell "give SQLite a transaction block" what api you mean by that? Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users