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! > > ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/