Subject Re: [firebird-support] Problem with multiple isql sessions
Author Helen Borrie
At 05:01 PM 22/04/2007, you wrote:
>I'm new to firebird but have experience with other databases (MySQL,
>PostgreSQL, Oracle, ...).
>Setup worked well but I'm having the following problems:
>1.) Other session not updated:
>Session 1 with isql:
>Session 2 with isql after commit of session 1 (isql already open):
>SELECT COUNT(*) from tablename; -- Still 0, works only after quitting isql
>and restart it.

All you actually need to do is COMMIT the transaction in Session 2
first! isql's transaction is by default in snapshot (concurrency)
isolation so your existing isql session won't see what other
transactions have done until after the commit. (isql will then open
a new transaction: no need to quit to achieve this!!)