Solved

how to use Rollback and Commit in firebird

Posted on 2014-04-09
3
1,219 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query assistance 16 46
physical_device_name field in SQL 3 38
Database ERD 4 77
Star schema daily updates 2 35
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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…

756 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