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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users