Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

how to use Rollback and Commit in firebird

Posted on 2014-04-09
3
Medium Priority
?
1,387 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
[X]
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
  • 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 1000 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

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

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

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

636 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