>What's the method name?
>Could you anyone give some link about it.
>
>Thanks for answering my question
BEGIN TRANSACTION starts a transaction.
END TRANSACTION confirms changes.
ROLLBACK is the "undo" command.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)