how to use Rollback and Commit in firebird

Hi, can anyone tell me how to use Commit, Rollback transaction in the code (attached file - rather large) , if possible

procedure-TFactuuraanmaak.docx

thx
Mario
mariowayAsked:
Who is Participating?
 
Nick UpsonPrincipal Operations EngineerCommented:
try thinking less about the code and more about what you are trying to achieve.

think about how the process groups database access together and each group needs to be within its own transaction. e.g.

you want to add a line item to an invioce:

start transaction
select current total from invoicehead
insert into invoiceline
update invoicehead current total
commit
0
 
Nick UpsonPrincipal Operations EngineerCommented:
you already have commit etc in the code, can you be more explicit about what you are looking for
0
 
mariowayAuthor Commented:
well, I know that I have to remove the commit statements, but where do I start the transaction (at this moment active is on), and where to put the rollback, or commit ( in the middle of the code another subform can be called,....  )
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.