Helen Borrie wrote:

>
> At 08:48 AM 11-03-02 -0300, you wrote:
> >Yes, tanks Helen. I realize that I can start a new read commited
> >transaction at ISQL, then the commited transactions will be visible. By
> >the way, what is the default transaction in ISQL?
>
> I think it is SNAPSHOT and can't be changed.
>

Actually it can - see the syntax for SET TRANSACTION in the lang. ref.

But it only changes the default user transaction - the one for DML
statements. DDL statements are in a separate transaction that
auto-commits. If auto-commit is turned off everything should then
execute in the user transaction.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further