Subject | Re: [firebird-support] recompile computed field BLR |
---|---|
Author | Radu Sky |
Post date | 2006-05-15T20:50:34Z |
Milan Babuskov wrote:
Of course, I could do a search replace in the sql file for computed
field (which I did in the end), but i was wondering if recompiling can
be done.
Radu
> Radu Sky wrote:AFAIK, extracting databases does not extract system domains.
>> 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
>
Of course, I could do a search replace in the sql file for computed
field (which I did in the end), but i was wondering if recompiling can
be done.
Radu