Re: Des2k does not generate trigger to store calculated value in base table column

Derivation expression in Detailed Usages only produce non-base table items. You need to put the derivation expression in the Column definition, or hack the code in the generated form (which is easy to do).

armaghan_at_usa.net wrote:

>I have following columns in emp table
>sal, comm and netsal which is sal + comm
>
>I set derivated expresstion for netsal to sal + comm in column
>text/derivation expression in detail usage of table.
>
>When form is generated it correctly shows netsal column with sum of sal +
>comm but does not store this value in table
>
>I have spent a whole day trying to find my mistake but invain.
>
>I shall greatly appreciate any hint or help
>
>Thanks in advance
>M. Armaghan Saqib
>armaghan_at_usa.net
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

-JJ

Visit our new website at http://www.jeffreyjacobs.com

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 650-571-1457, FAX: 800-665-1379
 Email: jmjacobs_at_ix.netcom.com
 Web: http://www.jeffreyjacobs.com Received on Mon Jul 20 1998 - 21:20:19 CEST