Subject Re: [firebird-support] using a stored procedure to return the value for an existing field in the table
Author Dimitry Sibiryakov
24.03.2017 17:26, avert@... [firebird-support] wrote:
> is there a way i can write a StoredProcedure or trigger to have the "code" in the database
> return that value i want for the existing column and not just return the table data for
> that column?

Create a new table, pump all data into it, drop old table, create a view with name
Parts which select from new table and performs needed calculation, write triggers to make
it updateable. That's all.