Answered TRANSACTION block

[Stefio Almeida]

Hi Forum,

If a LEAVE statement is encountered(gets satisfied) within a DO TRANSACTION block does Progress treats it has an error?

Regards,
Stefio

 

[Cringer]

No I believe not.

 

[Stefio Almeida]

Yes, i checked that with a small program.

Thanks Cringer.

 

[RealHeavyDude]

LEAVE does not undo the transaction. You need to code UNDO, LEAVE in order to undo the transaction.

Still you should be carefully when you use database triggers as these will fire on the end of the buffer or transaction scope - whichever comes first. Could be that things that they expect are not present because you committed the transaction without executing all code in the block and therefore might produce an error.

Heavy Regards, RealHeavyDude.

 

[tamhas]

To reinforce RHD, the bottom line is that you should code so that questions like this don't arise.