Hi,
I have a c# program which has to process a large amount of updates at one
time.
I have previously used:
connection.beginTransaction()
commandObject
<loop>
update SQLite with command object
<loop end>
commandObject.Transaction.Commit
This worked nicely.
But now I have modulised my code so that I have a generic
updateFunction(String) inside this function I create a commandObject and do
the update which is fine, but....
Now I have reached a point where I want to process a large amount of updates
therefore need transaction boundaries. So now I have
connection.beginTransaction()
<loop>
updateFunction(String)
<loop end>
????How can I commit, I dont have a command object that performs the
commit/endTrans, I dont want to commit inside the updateFunction ?????
Any help is greatly appreciated
Dan
--
View this message in context:
http://www.nabble.com/c--.net-beginTrans...where-is-endtrans--tp18898927p18898927.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
