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!
