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!