List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 22 2010 12:14am
Subject:Re: Performing subtraction between fields
View as plain text  
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
Thread
Performing subtraction between fieldsb21 Aug
  • Re: Performing subtraction between fieldsMark Goodge21 Aug
  • Re: Performing subtraction between fieldsAshish Mukherjee21 Aug
    • Re: Performing subtraction between fieldsAshley Stars21 Aug
      • Re: Performing subtraction between fieldsAshish Mukherjee21 Aug
        • Re: Performing subtraction between fieldsDan Nelson22 Aug
  • Re: Performing subtraction between fieldsChris W21 Aug