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

> At 20/03/2002 11:41 PM, you wrote:
> >It seems like I'm teasing you, but no.
> >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.

>
> Just to add to my last reply. I just tried Ann's suggestion, in my
> application, to have additional steps to perform the wanted task and it
> works great and doesn't give any errors. And, I can do the backup.

So, is your case totally repeatable at will with an example table and a few
rows? It seems like a good test case.

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