Solved

How can I write to database directly after I click Save on DBNavigator

Posted on 2008-10-23
2
260 Views
Last Modified: 2013-11-23
I use firebird database engine and IBtable and DBNavigator to access to and edit tables,
but after I click the "Save" button on the DBnavigator nothing is written to database, how can I make the application write to database directly after I click Save on DBNavigator?
0
Comment
Question by:Livingod
2 Comments
 

Accepted Solution

by:
the_good earned 125 total points
ID: 22792299
I assume you have a DBsource and IBtable components between dbnavigator and database Source

since you use  Firebird You need to drop an IBtransaction component from Interbase tab

for the DBnavigator onclick event write this code to push the updated data to physical database  

IBtransaction1.commit;  {this will close the table as default}
//if you are using IBtable add this line too
IBtable1.active:=true;

You can see the database file updated with the new commit  ;-)
0
 

Author Comment

by:Livingod
ID: 22792306
Wow wonderful! Thanks for your help : )
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now