Subject Re: [firebird-support] iSQL Console - refresh data
Author Helen Borrie
At 03:51 PM 16/08/2005 +0530, you wrote:


>Hi,
>
>Can anyone tell me why the iSQL console (active session) does not show the
>result of any DML statement executed and committed through a client
>application?

Because isql runs its transactions by default in snapshot isolation.


>Though the changes appear when I open another instance of iSQL…

All you need to do is issue a COMMIT statement in isql, before you run your
next query.

./heLen