Subject Re: [firebird-support] recompile computed field BLR
Author Milan Babuskov
Radu Sky wrote:
> My purpose for this question is that I have many computed field (easy
> financial stuff, like calculating tax etc) and I have the computed
> domain (let's say RDB$100) shared between all fields through the db.
> Since I have the same structure for all fields in all tables used to
> performed that computation, I assumed it's working and it is.
> My problem is that I want to change that system domain used for computed
> fields. Drop'em and recreate is the right solution, but I have to
> recreate almost the whole db from scratch since these fields are
> referenced many times and levels.

You could:

- dump the sql script that creates database (using isql -x)
- edit that and change definition of domain
- run it to create empty db
- pump data from existing db to new db

Milan Babuskov