Hi, > i´m using firebird-server-classic-2.1.3.18185.0-5mdv2010.0
In that case, here's how DBW does it for you: // delete field dependencies for field "MYTESTFIELD" delete from rdb$dependencies where rdb$dependent_name = (select f.rdb$field_name from rdb$fields f join rdb$relation_fields rf on rf.rdb$field_source = f.rdb$field_name where rf.rdb$relation_name = 'DML_TEST1' and rf.rdb$field_name = 'MYTESTFIELD'); // add temporary test field ALTER TABLE DML_TEST1 ADD DBW$$TEMP COMPUTED BY ( 'test' || 'moere' ); // copy generated BLR from temp test field to your test field UPDATE rdb$fields SET RDB$COMPUTED_BLR = (select RDB$COMPUTED_BLR from rdb$fields where rdb$field_name = (select rdb$field_source from rdb$relation_fields where rdb$field_name = 'DBW$$TEMP' and rdb$relation_name = 'DML_TEST1')), RDB$COMPUTED_SOURCE = (select RDB$COMPUTED_SOURCE from rdb$fields where rdb$field_name = (select rdb$field_source from rdb$relation_fields where rdb$field_name = 'DBW$$TEMP' and rdb$relation_name = 'DML_TEST1')) WHERE rdb$field_name = (select rdb$field_source from rdb$relation_fields where rdb$relation_name = 'DML_TEST1' and rdb$field_name = 'MYTESTFIELD'); COMMIT; // create valid new dependencies insert into rdb$dependencies select * from rdb$dependencies where rdb$dependent_name = (select f.rdb$field_name from rdb$fields f join rdb$relation_fields rf on rf.rdb$field_source = f.rdb$field_name where rf.rdb$relation_name = 'DML_TEST1' and rf.rdb$field_name = 'DBW$$TEMP'); // drop temporary computed field ALTER TABLE DML_TEST1 DROP DBW$$TEMP; If this doesn't help for you, I'd be interested in a copy of the database to see what's going on. ;) Hope this helps. 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/