Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

how to use Rollback and Commit in firebird

Posted on 2014-04-09
3
1,170 Views
Last Modified: 2014-04-19
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
0
Comment
Question by:marioway
  • 2
3 Comments
 
LVL 19

Expert Comment

by:NickUpson
ID: 39990003
you already have commit etc in the code, can you be more explicit about what you are looking for
0
 

Author Comment

by:marioway
ID: 39990022
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
 
LVL 19

Accepted Solution

by:
NickUpson earned 500 total points
ID: 39992353
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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question