Subject Re: [firebird-support] Data updates in multi-user
Author Woody (TMW)
> I have a small problem where i have two machines (one windows
98se[firebird
> server] and windows 2000 sp3 [firebird client], this is just the setup
that
> i have for testing). Basically my program is one both machines running at
> the same time, now when i change data on one machine, the changes made do
> not appear on the other machine until i exit out of my program and restart
> it again.
>
> my database connection string is "LAPTOP:D:\Dev\Test\Test.gdb" now i
> thought that by doing this any changes made on one machine will be able to
> be seen on another machine.
>
> can some one tell me what i may have done wrong or point me in a direction
> that will help me.
>
> my program is using the interbase components that come with delphi 7
> professional.

Set your transaction components to read-committed. They default to snapshot
mode which means you won't see changes made by other users until you stop
the transaction and restart it. Using read-committed transactions you can
just re-query the database to see the changes. See the IB/FB documentation
to understand the differences between transaction modes.

Woody (TMW)
Freeware Page: http://users.eonet.net/woodytmw

"Start every day off with a smile and get it over with."
-- W. C. Fields