Hello Carsten,

> I originally changed the length of a varchar field.
> But in another db with the same metadata (i thought) and a tool.
> I copied the command that this tool exceuted.
> But in this db it was another field.
> BTW is there a command for firebird to change the length of a
> varchar field without hacking system tables ?

I'm pretty critical against such tools, which are manipulating
system tables without your knowledge directly. So, either
use only pure DDL statements yourself, or give InterBase
Workbench (http://www.interbaseworkbench.com) a try. Martijn
Tonies (the author of InterBase Workbench) has always stated,
that nothing magic is done behind the scenes. I'm pretty
happy with it ...

Regards,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com