On Apr 17, 2008, at 5:05 PM, Fin Springs 20dkom502-at-sneakemail.com | sqlite| wrote: > If I do: > > sqlite3_exec(..."UPDATE foo..."...) > > and then: > > numChanges = sqlite3_changes(....) > > I get the number of updated rows back. My question is, if I changed > the statement in the single exec call to "BEGIN IMMEDIATE;UPDATE > foo...;COMMIT", will sqlite3_changes still return the same value as > before? Or do I need to make the BEGIN/COMMIT in separate exec calls > from the UPDATE to get my count? > > _______________________________________________
A related question: If I do an UPDATE not in an explicit transaction, it will create an implicit transaction. Is that implicit transaction the equivalent of wrapping the UPDATE in BEGIN IMMEDIATE....COMMIT? If not, which BEGIN x is it equivalent to? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
