Solved

Refresh aplication using Delphi7+Firebird1.5

Posted on 2004-04-06
4
386 Views
Last Modified: 2010-04-05
hi , people  
 
I'm developing a application Client/Server.  
The Database (FireBird) is Located in the Server. And the Clients is working in  machines in the same network.  
Problem: The Inserts only is visible in the local client, and other client don't view the modifications, It's visible if client restart the program and reopening DataBase.  
I'm using IBX components (IBTable, IBQuery).  
I tried to use "Table.Refresh" OR ("Table.Close" / "Table.Open") but this solutions not worked.  
Somebody knows if exists some solution for this problem.
Thanks...
0
Comment
Question by:emaia
[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
  • 3
4 Comments
 
LVL 12

Expert Comment

by:esoftbg
ID: 10769577
Do a double click on the IBTransaction component and choose Snapshot, I think this is the lowest isolation level. I have not network and can not taste it.

I hope it will work successful,
emil
0
 
LVL 12

Accepted Solution

by:
esoftbg earned 125 total points
ID: 10769633
After commitment of the transaction it will be visible modifications, without client restart the program and without reopening DataBase.
If selecting Snapshot isolation level does not effect, try consecutively other levels....

emil
0
 

Author Comment

by:emaia
ID: 10769830
Emil,  
 
I tried your first suggestion  didn't work. But I did  try  
"Read_Committed"  option and  worked.  
You can explain for me what happening in my application when I choose this option.  
Thanks one more time.  
 
-- Elielson
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 10769905
I found this explanation:

ISOLATION LEVEL determines how a transaction interacts with other simultaneous transactions accessing the same tables. The default ISOLATION LEVEL is SNAPSHOT. It provides a repeatable-read view of the database at the moment the transaction starts. Changes made by other simultaneous transactions are not visible.

SNAPSHOT TABLE STABILITY provides a repeatable read of the database by ensuring that transactions cannot write to tables, though they may still be able to read from them.

READ COMMITTED enables a transaction to see the most recently committed changes made by other simultaneous transactions. It can also update rows as long as no update conflict occurs. Uncommitted changes made by other transactions remain invisible until committed.

emil
0

Featured Post

Industry Leaders: 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

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 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