Adam wrote:

> >>From Firebird 1.5.3 Dialect 3
> >
> > Using iSQL:
> > ---
> >
> > SQL> select current_timestamp from RDB$DATABASE;
> >
> > CURRENT_TIMESTAMP
> > =========================
> >
> > 2006-10-09 15:32:13.0000
> >
> > SQL> select current_timestamp from RDB$DATABASE;
> >
> > CURRENT_TIMESTAMP
> > =========================
> >
> > 2006-10-09 15:32:15.0000
> >
> > SQL>
> >
> >
> > ---
> >
> > They look pretty different to me.
> >
> > Note that I executed the query:
> >
> > select current_timestamp from RDB$DATABASE;
> >
> > then paused for a two seconds, pressed the up arrow and pressed enter.
> >
> > Obviously if you run a script with both of them it will almost always
> > give you the same time for both.

At 05:07 PM 9/10/2006, Boguslaw Brandys wrote:

>I guess that ISQL do autocommit for you...

You guess wrong. You do not get autocommit in isql except for DDL
statements with SET AUTO ON. A single separate transaction runs for
all DML statements and COMMIT or ROLLBACK is required to end that transaction.

Adam is correct. I don't know what Hans is seeing, other than
multiple inserts resulting from a single statement execution.

./heLen