shivaprasath143
New Member
in which are the progress blocks transaction happens?
transactions
- Thread starter shivaprasath143
- Start date
RealHeavyDude
Well-Known Member
In a nutshell:
Every statement that changes the database or a FIND with an EXCLUSIVE-LOCK causes a transaction. The transaction is then scoped to the next outer block with transaction capabilities. That is for example a procedure, an internal procedure or function, a FOR or REPEAT block. A DO block does not have transaction capabilities per default, you need to add the TRANSACTION keyword to it for that.
If you compile with the LISTING option an output is generated that will indicate for each block whether a transaction is scoped to it or not.
Heavy Regards, RealHeavyDude.
Every statement that changes the database or a FIND with an EXCLUSIVE-LOCK causes a transaction. The transaction is then scoped to the next outer block with transaction capabilities. That is for example a procedure, an internal procedure or function, a FOR or REPEAT block. A DO block does not have transaction capabilities per default, you need to add the TRANSACTION keyword to it for that.
If you compile with the LISTING option an output is generated that will indicate for each block whether a transaction is scoped to it or not.
Heavy Regards, RealHeavyDude.
