| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
01-23-2007, 07:43 PM
|
|||
|
|||
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.     
|
