?
Solved

how to use Rollback and Commit in firebird

Posted on 2014-04-09
3
Medium Priority
?
1,422 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 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
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…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 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