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

Reply via email to