Subject | Enclosing SENTENCES in one transaction |
---|---|
Author | JJHERMOSILLO |
Post date | 2005-08-16T21:14:13Z |
Hi people, i'm using Firebird 1.5.2.
I need to enclose some setentces in one transaction.
Example.
Start Transaction
Select
Update
Delete
Insert
Call a StoreProcedure
If No Errors Then Commit Else RollBack.
I haven't found information abot how to do these things in FireBird.
I know that FireBird has the auto commit mode by default.
Does Any Body knows How can i do that kind of thins using FireBird?
What kind of instructions should i use ?
Thanks A Lot Guys :D
I need to enclose some setentces in one transaction.
Example.
Start Transaction
Select
Update
Delete
Insert
Call a StoreProcedure
If No Errors Then Commit Else RollBack.
I haven't found information abot how to do these things in FireBird.
I know that FireBird has the auto commit mode by default.
Does Any Body knows How can i do that kind of thins using FireBird?
What kind of instructions should i use ?
Thanks A Lot Guys :D