I haven't write a Rollback command. I need some advices.
I need to make to actions:
2.StrSql="INSERT INTO MY_TABLE SELECT * FROM MY_REMOTE_TABLE");
number 1 should be executed before number 2, because number 2 may insert MY_TABLE
the same records (It will cause primary key violation).
actually I need to roolback the two steps if number 2 is not avalable.
How do I roolback ????
Thanks in advance