Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
A trigger? Although I like the view idea more.
Chucho!
Captain Pedantic wrote:
> "Michael Krzepkowski" <mkrzepkowski@hotmail.com> wrote in message
> news:Pfg8d.199356$%S.181424@pd7tw2no...
>
>>sumGirl wrote:
>>
>>>Let's say I have two columns: AmountOne and AmountTwo. I'd like to
>>>create a column that is dynamically populated called AmountCalc that
>>>would subtract AmountOne from AmountTwo. Since either of the two
>>>columns can change, AmountRemaining will always be correct. Is this
>>>doable in IDS? I am using IDS 9.40 if that makes a difference.
>>>
>>>I believe in MSSQL Server there is a way to define a column to do this
>>>so that you don't have to remember to manually change the
>>>AmountRemaining column if one of the other two values gets changed. We
>>>are trying to reproduce the same functionality in Informix.
>>
>>Use a view.
>
>
> Or get the old man to do it for you, love.
>
>
>
sending to informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.