Subject Re: [firebird-support] Alter table error
Author Helen Borrie
At 06:22 AM 17/08/2004 -0700, you wrote:

>Thanks, this was my issues.
>So it seems that if you have viewed the schema info in any way it will
>lock the tables and not allow update?

If you viewed them and forgot to commit the transaction, yes. If you are
using isql, it's as simple as entering a COMMIT; statement. In the better
graphical tools, there are usually buttons for committing the transaction
and for unpreparing the statement. You'll have problems with some of the
rougher tools, that always do CommitRetaining and don't have an option to
perform a hard commit. In that case, exiting cleanly from the tool and
then starting it up again, without doing anything else with the tool,
should do the trick.