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!
COURSE of the MONTH
14 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Refresh aplication using Delphi7+Firebird1.5
Posted on 2004-04-06
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...
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...
[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
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
I hope it will work successful,
emil
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
If selecting Snapshot isolation level does not effect, try consecutively other levels....
emil
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
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
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work. Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month14 days, 1 hour left to enroll
801 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.