SQL 99 answer.
Re: How do I make one field be a function of another?
You have two options.
1. update the calculated field by means of a trigger for insertion and updates or
2. create a view calculating the "virtual" field.
In any case, updating the calculated field makes no sense at all.
|