Henry,

Once you BEGIN TRANSACTION you either need to END TRANSACTION to commit the data changes or ROLLBACK to revert the changes before you can do any other queries.

A transaction should be short lived and should be used whenever you have multiple table updates that need to be committed or reverted as a whole group.

>if i have example listing like this:
>
>begin transaction
>..
>rollback
>..
>end transaction
>
>and in the middle of my listing, i must do requery for my local view, how can i do requery? or tricky my problem.