Hi all;
I have a problem with rollback a delete query.Here is what i wrote;
BEGIN TRANSACTION trans1
delete from auto where auto_id=5
and this delete the record whose auto_id=5
The problem is when i wrote ;
ROLLBACK TRANSACTION trans1 i get get an error message like
"there os no transaction or savepoint as named trans1"
All these stuff works when i tried with insert query.It is obviously that i am doing something wrong.What shall i do?
I have a problem with rollback a delete query.Here is what i wrote;
BEGIN TRANSACTION trans1
delete from auto where auto_id=5
and this delete the record whose auto_id=5
The problem is when i wrote ;
ROLLBACK TRANSACTION trans1 i get get an error message like
"there os no transaction or savepoint as named trans1"
All these stuff works when i tried with insert query.It is obviously that i am doing something wrong.What shall i do?