On 21 Jul 2011, at 3:29pm, Alok Singh wrote: > Dim tx = cons.BeginTransaction()
Sorry but you're using a library I'm not familiar with. Judging from what you wrote the first time I'd think more like .... mycommand.CommandText = "BEING TRANSACTION" mycommand.ExecuteNonQuery() FOR z = 1 TO count1 ... NEXT z mycommand.CommandText = "COMMIT" mycommand.ExecuteNonQuery() cons.close() Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users