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.
Waaaaw, what a difference in support with IBO, most of the time when I asked something there, I got a arrogant answer. This is really great and I must say, there is a significant difference in speed that FIBPlus is faster! >>Nico Callewaert
