Hi Martijn, i did what u said, but when i try to alter the field in
Database Workbenc it shows me the same thing:

Column RAZAO_SOCIAL from table CLIENTE is referenced in RDB$1536

i cant find this dependencie, i´m so disappointed with Firebird :-(

could u explain me in detail how to do that ?

thanks a lot



Em 08-04-2013 10:32, Martijn Tonies escreveu:

>
> Hello Gugui,
>
> > I´m just trying to increase the varchar field type, so i´ve solved all
> > the dependencies, but there is one that i can´t solve and it is a
> > Computed Field type !
> >
> > when i try:
> >
> > ALTER TABLE CLIENTE ALTER RAZAO_SOCIAL TYPE VARCHAR(60);
> >
> > returns:
> >
> > Column RAZAO_SOCIAL from table CLIENTE is referenced in RDB$1536
> >
> > in the RDB$DEPENDENCIES table:
> >
> > RDB#DEPENDENT_NAME RDB$DEPEPENDED_ON_NAME RDB$FIELD_NAME
> > RDB$DEPENDENT_TYPE
> > RDB$1536 CLIENTE RAZAO_SOCIAL 3
> > RDB$1536 CLIENTE IDCLIENTE
> > 3
> > RDB$1536 PEDIDO IDCLIENTE
> > 3
> > RDB$1536 CLIENTE [null]
> > 3
> >
> >
> > RDB$DEPENDENT_TYPE = 3 = Computed Field
> >
> > how to solve it ?
>
> You cannot, easily. ;)
>
> Download Database Workbench at www.upscene.com - alter the computed by
> field
> and it will generate the required statements for you.
>
> Note: it's tricky, but has been proven as working.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
>