Problem with data not being visible between workstations
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
Question: I am using FIBPlus 4.7x and Firebird 1.5 RC6. I am having
a problem with data not being visible between workstations. One workstation
will add a record and the others can't see it unless they close and reopen the
program. Must I really close and re-open the dataset in order to see changes
to my dataset?
Answer: Probably you are using Snapshot isolation, you need to change
the transaction isolation to ReadCommited in the transaction component, but
you also need to read some information about transaction handling with Firebird,
search this web site for transaction documents. Surely refresh or CloseOpen
will do it and the dataset will seem to remain open. Good idea to get a bookmark
first. You can try FullRefresh.
Well, the ballots are in and the votes for the 2003 Delphi Informant Readers Choice Awards have been tallied - Congratulations Devrace, you are the runner-up in Database Connectivity category! >>Debbie Holmgren, VP of Sales, Delphi Informant Magazine
