Re: Performing subtraction between fields

[Dan Nelson]

In the last episode (Aug 21), Ashish Mukherjee said:
> Well, since you are searching that column, it's probably a good idea.
> 
> Possible scenarios for not storing computed values -
> 
> 1)  Data integrity - say, the columns A and B are updated but C does not get
> updated, resulting in an anomalous situation

You could use a trigger that updates C whenever A or B changes, to make sure
it stays in synch.

-- 
	Dan Nelson
	dnelson@stripped