I already reported this to
firebird-odbc-devel@..., but
I want to repost it here for second opinions.

I know that Firebird has sophisticated versioning feature.
But I am not sure the following is a feature or a bug of
the ODBC driver.

My application (it does not matter if this is a PowerBuilder or Java
one)
opens a Firebird ODBC connection. Since I want to implement
transaction
by myself, I turn off the autocommit flag.

Then, my application will NOT be able to see any commited changes
BY OTHER APPLICATIONS since I open
the connection or since the last commit. For example,

For simplicity, at time t0, my app issues
select name from employee where id = 11
==> "Original name"

Then, at time time t100 (several minutes later), another external app
issues
update employee set name = 'New name' where id = 11;
commit;

Then, at time t200 (several minutes later), my app issues
select name from employee where id = 11
==> "Original name"


Why did my app NOT see the "New name"?


Ben