"Daniel Rail" <daniel@...> wrote in message
news:5.1.0.14.2.20020321064907.03daa008@......

> At 20/03/2002 11:41 PM, you wrote:
>
> >It seems like I'm teasing you, but no.
> >Both DYN (metadata mangler) and DFW (data and metadata mangler at commit
> >time) are industrial-strength can of worms. Avoid getting in their way or

it

> >would be like a train hitting a tricycle.
> >You mixed DDL and DML. Usually, tools handle auto-commit DDL and manual
> >commit DML, but this is not mandatory to use separate transactions for

them

> >and in isql, it's an option. By renaming a field to the original name, I

can

> >imagine (but I'm not sure) how the disaster happens. You need the

commits.

>
> Everything is autocommitted. I use IBO with the IB_Transaction settings
> AutoCommit=True and ServerAutoCommit=True.

AutoCommit is not exactly the same than manual hard commits.
:-)
Autocommit might preserve some context from the prior txn.
If you find later a worse problem that can't be solved with manual commits,
you will have to try the detach/re-attach trick.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing